How to copy a table programmatically

[ping99]

Hi all,

How to copy a supplier table in NorthWind.mdb to NorthWind2.mdb programmatically ? and also rename to become
suppliernew in Northwind2 ?

Please assist me in coding or advise how to do it ?

TIA

Ping

 

[fneily]

You could create a macro that looks like this:
Echo Echo On = No
SetWarnings Warnings On = No
TransferDatabase Import
Microsoft Access
C:\BlabBlab\NorthWind.mdb
Table
SupplierTableName
SupplierNew
No
Echo Echo On = yes
SetWarnings Warnings On = Yes

 

[fneily]

Oh yeah, you would place that macro in NorthWind2.mdb

 

[ping99]

Thank you very much,

It works great.