PDA

View Full Version : Sleeper: Data from Access through network



alaou
06-06-2011, 04:37 PM
Hi guys

First of all, i'm new to VBA... So,forgive any mistake...
Here is my unsolved task.

There is a database that informed every hour.I want to take some values from a table of the database (some,not all) and import them to an excel file, every hour....
NOTE: the database is in another pc, p.s. 64.64.64.1
and the excel is in 64.64.64.2

Suggestions?!

Kenneth Hobs
06-07-2011, 11:53 AM
If you network them, then you can access them. When you say Access, do you mean Microsoft Access for the database?

Normally, one would set a virtual drive for a network computer or network folder. For your computer's name, click Start and type %computername%. Typically, one would share a folder rather than sharing the whole computer.

So, if my computername is ken and my shared folder is called MSA and the file is Test.mdb then the path is \\ken\MSA\Test.mdb.

If you are going to use ADO for MSAccess files then I would recommend http://www.erlandsendata.no/english/index.php?t=envbadac