copy table

[mdmilner]

Other than something like a Maketable, is there a VBA one-line technique to simply copy a table? Or any object for that matter.

Hmmm, DoCmd.CopyObject

Looks like maybe I posted too quickly.

 

[Corticus]

Hi mdmilner,

Try:
DoCmd.CopyObject , "myTable2", acTable, "myTable"

myTable2 is what you will name the newly copied object
acTable is a constant meaning your copying a table, you can specify other object types in this parameter
myTable is the name of object to copy

If you start typing the method in the VB editor, Access will tell you where you are in the arguments, and provide choices when applicable.

Hope this helps,

 

[mdmilner]

Yep, I started looking and didn't get anywhere - figured I could get a quick answer, and found what I was looking for in the next couple minutes.

Was using this for a quick table copy.
Rather than build a custom import wizard, I decided to piggy back off:

Runcommand acCmdImport (runs the default import wizard)

But I couldn't guarantee that the table name the user wants would be what they use at the end of the wizard. So, I wanted to check and then copy to new/delete old.

Still feels a little cumbersome, but, it'll work. (works already )

Mike

 

[Corticus]

I hate Access wizards. They sometimes use some really odd methods af getting where you want to go. Like the combobox wizard that takes you to the record you selected. What is that?

Glad you figured it out.

 

[mdmilner]

Guess you can call this a shortcut. I've already got code samples scattered in 3 or 4 other databases I've built that do most of what I'll need for my own custom import "wizard" - I just need to assemble it into a slick/uniform GUI.

Mike