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

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