Jan 10, 2006 #1 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.
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.
Jan 10, 2006 #2 PHV MIS Nov 8, 2002 53,708 FR 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 Upvote 0 Downvote
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