make table from one mdb to another

[gbfell]

I need a way of selecting all records from a table from one mdb into another. simple, right? how do i do it? do i need multiple connections?

 

[CCLINT]

INSERT INTO Tablename (field1, field2)
IN 'C:\Temp\myJetDB.MDB'
SELECT field1, field2
FROM myDBFTable


Please note the single quotes around the path.

http://msdn.microsoft.com/library/d...y/en-us/office97/html/output/F1/D2/S5A328.asp

[/b][/i][/u]*******************************************************
[sub]General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!

 

[CCLINT]

And, you yould also use the SELECT INTO (watch it - it has a different syntax), which will also create the table if it doesn't already exist - but produces an error if it does already exist. [/b][/i][/u]*******************************************************
[sub]General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!

 

[gbfell]

fantastic i'll try it now.