Insert records from external database 1

[3239]

Hi everyone.

I have a query in my current database that pulls information from an external database. What I am trying to do is insert the records from the external database into related tables in the current database.

Thanks.

 

[PWise]

INSERT INTO Currentdbtablename( Field1,field2,.....)
SELECT Field1,field2,.....
FROM externaldatabasetablename IN 'drive:\Path\dbnametest.mdb';

 

[3239]

Thanks for your response pwise. I was able to insert records into a single table, but is there a way to insert information into two tables? Or will I have to you two seperate insert into statements.

 

[PWise]

I think you will have to use two insert statments

 

[3239]

Thanks.