asked on

Access 2007 RunSavedImportExport from macro

I'm running Access 2007. I have a saved Import Specification that I need to run from a macro. I can see the macro command "RunSavedImportExport" but the drop-down list which should contain import specifications is empty, and Access won't let me enter the specification name manually.

Any thoughts on why this is happening?

Thanks!

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

davewalter1

ASKER

Ah, you weren't clear in your previous. I'd thought you'd mentioned those two actions as examples of actions that were available after clicking "Show All Actions."

This worked perfectly, and earns you another 500 points into the bargain!

Thanks.

DWMinney

Access 2010 - I need to import a .txt file. I have a specification and have imported it correctly and saved the import und the Saved Imports section. Now I want to import it using a macro but can't find the command to pull up/run the Saved Imports section.. I thought it was RunSavedImportExport but can't find it in the Macro actions.

davewalter1

ASKER

Your problem sounds very similar to mine. Read the solution that I accepted above -- it worked for me when I was importing a text file. I couldn't use "RunSavedImportExport," and I'm guessing you can't, either.

DWMinney

Come to find out there are a lot of people having this problem. Seems there is a bug in 2010 when it comes to importing using a macro. Thanks for your help.