create table from table

  • Thread starter Thread starter Bill H.
  • Start date Start date
B

Bill H.

What is the VBA code for creating an empty table from an existing empty
table?

Thx.
 
What is the VBA code for creating an empty table from an existing empty
table?

Thx.
Click to expand...

DoCmd.CopyObject , "NewTableName", acTable, "OldTableName"
 
Thank you!

but how to automatically delete the newtablename if it already exists
without getting the access prompt?
 
You must log in or register to reply here.

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

VBA - retrieve data on last create named range from previous inserted named range 0
How to export table from outlook into ms access table? 0
DoCmd.TransferDatabase Error 1
Make Table Query - Properties? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Automatically generate a "create table" statement 5
How to Populate Data from a table to another 0
Error Codes 1

Back
Top