Importing tables from one access db to another

G

Guest

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
 
D

Douglas J. Steele

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
 
Top