Importing tables from one access db to another

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import table from one db into another 5
Import Excel named range into Access 2
Create a new DB by importing from another DB 1
How to export table from outlook into ms access table? 0
importing dilemma 1
Importing data 3
Import Users and Permissions? 1
MS Jet db engine stopped 2

Back
Top