Insert Tables from another Database 1

[briglass]

I have 2 access database files, apple.mdb and banana.mdb.

I would like to know how (using SQL or ADO) to copy a table from within banana.mdb and paste it into apple.mdb from visual basic.

This would be really helpful!

 

[smedvid]

I don't have the syntax, but look up Database.Transfer... Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/

 

[sreek2]

Please Try the Following Query it works for you...


Dim Db1 As DAO.Database
Set Db1 = OpenDatabase("C:\apple.mdb&quot

Db1.Execute "Select * INTO [TableName] From [TableName] IN 'C:\banana.mdb'"

Thanks
Sreekanth

 

[PalaniappaBabu]

Pls try this.....


Dim cn as ADODB.Connection;

cn.open("apple.mdb&quot

sql = "SELECT oldTable.* INTO newTable IN 'banana.mdb' FROM oldTable"

cn.execute(sql);

 

[briglass]

Thanks! This is the one that ended up working for me:

Set Db1 = OpenDatabase("C:\apple.mdb&quot

Db1.Execute "Select * INTO [TableName] From [TableName] IN 'C:\banana.mdb'"