How to automatically import a table from another database?

[longmatch]

I have a website powered by Access database and one table is imported from another database. How can I make this process automatic to avoid manually import.

big thanks

Haijun

 

[psemianonymous]

Consider using a linked table? That way you get the most "up-to-date" information and it's seamless.

The catch is that the web server has to be able to "see" the second (linked) database as well as the one it is already using.



Bottom line: there is no such thing as "automatic import". If you need to periodically import data, you're going to have to set up something with Task Scheduler that will then "automatically" import the data for you.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[jdttek]

You could also run code to transfer spreadsheet on an Open or Load event. That way every time the app is opened, data is refreshed

JDTTEK