View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_5_] Jim Thomlinson[_5_] is offline
external usenet poster
 
Posts: 486
Default 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.