Import tables via Macro using Command

[bethabernathy]

Hi - I need to figure out how to import access tables from one database to another using a macro. I set the action on the macro to "RunCommand" and at the command line I see an option to set it to "Import". Now I just need to figure out how to import some tables from another Access database. Any help would be great. Thanks, Beth

beth@integratedresourcemgmt.com

 

[GingerR]

try macro action TransferDatabase instead. you'll see all the blanks to fill in.

 

[bethabernathy]

Great Thanks. Now I am stuck on the syntax to get to the source database. At "Source" I am typing:

c:\mydocu~1\goorin\Web\_datab~1\pensac~1.mdb

and or

c:\mydocu~1\goorin\Web\_datab~1\pensac~1

I am getting "invalid argument". I may need to simplify the location. Any suggestions? Thanks, Beth

beth@integratedresourcemgmt.com

 

[GingerR]

why the ~??
try typing the entire path. if that doesnt work, enclose in quotes.

"C:\My Documents\blah\mydb.mdb"