Accessing Remote MDB Database from Local Computer
 

I am very new to excel and I don't know any VBA. I am trying to figure
out if it's possible to have a local excel file access a database on a
remote server to sync up data. Any help would be greatly appreciated!
Thanks.

Accessing Remote MDB Database from Local Computer
 

It is possible to do through VBA but it is not a great project for the
newcomer to VBA or the faint of heart. There is a fair bit to it, if you mean
writing back to the Access database. If you just need to retrieve some data
from Access give this link a look. There are some downloads for you to play
with.

http://www.rondebruin.nl/accessexcel.htm

--
HTH...

Jim Thomlinson


" wrote:

I am very new to excel and I don't know any VBA. I am trying to figure
out if it's possible to have a local excel file access a database on a
remote server to sync up data. Any help would be greatly appreciated!
Thanks.