Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Append another database?

Status
Not open for further replies.

tjboats33

Technical User
Jan 10, 2006
2
US
oes anyone know if it is possible to append a table in another (different) database?

I am trying to create a database that imports data, then stores the data in another database.
 
If you don't like to play with linked tables, you may consider something like this:
INSERT INTO someTable IN '\path\to\database.mdb' ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top