Map Drive to SMB Share?

is there a way of connecting the Arduino to the network

Yes. The Arduino can be connected to the network using either an Ethernet shield or a WiFi shield.

The Arduino can then be a client (making GET requests to some other server) or a server (responding to GET requests).