If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing tables from one access db to another
How can I import tables from one access db to another without access being
installed. I would like to use the jet engine and c#. Is that possible and what libraries will I have to use? Thanks |
#2
|
|||
|
|||
Importing tables from one access db to another
You might be able to use INSERT INTO. The syntax is:
INSERT INTO target [IN externaldatabase] [(field1[, field2[, ...]])] SELECT [source.]field1[, field2[, ...] FROM tableexpression so something like: INSERT INTO Table1 IN OtherDB.mdb SELECT * FROM Customers -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) wrote in message ... How can I import tables from one access db to another without access being installed. I would like to use the jet engine and c#. Is that possible and what libraries will I have to use? Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Importing FoxPro data tables into Access 2003 | ABreyer | General Discussion | 1 | June 4th, 2005 06:09 PM |
2002 vs 2003 | Patrick Stubbin | General Discussion | 2 | May 17th, 2005 07:27 AM |
What is MDE | Charlie | General Discussion | 4 | August 24th, 2004 04:15 PM |
Importing tables and Relationships | Janine | New Users | 4 | August 24th, 2004 11:13 AM |
Linking Access 97 tables to Access 2002 tables | michaelwoodard | Database Design | 2 | August 13th, 2004 02:43 AM |