| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Files being saved to local computer instead of network server? | Excel Discussion (Misc queries) | |||
| running excel macros on remote computer | Excel Programming | |||
| Calling a macro on a remote computer | Excel Programming | |||
| FTP Accessing remote files where filenames are unknown | Excel Programming | |||
| Test whether current drive is local or remote? | Excel Programming | |||
Linear Mode
