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.