Besy way to Copy (or Import) a Table???

B

Bob Barnes

Looking for VBA code to either...

A - Copy a Table to another Access DB...

or maybe better...

B - Click a Button in a DB that does "File - Get External Data -
Import"....then I probably need to delete the Table so I don't get a "1"
suffix...BUT this Table is LINKED to a POS Card Swipe.

TIA - Bob
 
O

Ofer Cohen

To export a table to another MDB, you can use

docmd.TransferDatabase acExport,"Microsoft Access"
,"c:\MDBNameToExportTo.mdb",acTable,"TablesSourceName","TableDestinationName"
 
B

Bob Barnes

Ofer - Thank you.

Bob

Ofer Cohen said:
To export a table to another MDB, you can use

docmd.TransferDatabase acExport,"Microsoft Access"
,"c:\MDBNameToExportTo.mdb",acTable,"TablesSourceName","TableDestinationName"
Click to expand...
 
R

Ron2006

Both macros and docmd can

transfer (multiple types) to export/import/link

and

delete object
and copy object
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Tables 2
A Card Swipe/ Gate Check Table.... 5
Copy a linked table, including descriptions 2
Import to many to many table 7
importing a linked table from one file to another as a local table 3
HELP, PLEASE! Unlink a table 15
copy table with records from one DB to other DB 2
Import table from one db into another 5

Top