Copy a table from external database to current database.

[softlover]

I know the way to copy a table from current database to an external database. Here is the syntax,
DoCmd.CopyObject [destinationdatabase][, newname][, sourceobjecttype][, sourceobjectname]
Now I want to copy a table from external to current.

 

[PHV]

Have a look at the DoCmd.TransferDatabase method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[petrosky]

Hi softlover,

DoCmd.TransferDatabase acImport, "Microsoft Access", "c:\yourdatabasename.mdb", acTable, "TableName", "NewTableName", False

HTH.

Peter.

Remember- It's nice to be important,
but it's important to be nice