davewalter1
asked on
Where Is Microsoft Access RunSavedImportExport Command
I have an Access 2007 Import Specification that I want to run as a scheduled task in Windows XP. No problem with the scheduled task if I can get the macro to work, but the RunSavedImportExport command doesn't appear in my macro designer.
I've read that, to use this command, the location of the import specification must be trusted. I can't ferret out where Microsoft has chosen to hide these files, but I trusted the Office directory and its subfolders and am hoping it's hiding someplace in there. Still, I see no command.
Help! Or is there a switch which will allow this import specification be run from the command line in a scheduled task without a macro?
Thanks!
I've read that, to use this command, the location of the import specification must be trusted. I can't ferret out where Microsoft has chosen to hide these files, but I trusted the Office directory and its subfolders and am hoping it's hiding someplace in there. Still, I see no command.
Help! Or is there a switch which will allow this import specification be run from the command line in a scheduled task without a macro?
Thanks!
ASKER
Thanks!
I've gotten that far. As far as I can tell, everything that could possibly be related to Access or my database is trusted.
I've gotten that far. As far as I can tell, everything that could possibly be related to Access or my database is trusted.
<is there a switch which will allow this import specification be run from the command line in a scheduled task without a macro?>
you need to create a Macro that will be called in the command line.
in the macro, you will specify the name of the Import Specification you created.
and the other parameters..
the RunSavedImportExport is probably the steps that was saved in your manual importing process.. not the Import specification.
you need to create a Macro that will be called in the command line.
in the macro, you will specify the name of the Import Specification you created.
and the other parameters..
the RunSavedImportExport is probably the steps that was saved in your manual importing process.. not the Import specification.
ASKER
Thanks!
But I do have an import specification stored. And I know I need a macro. That's not a problem. I was hoping for a workaround since my macro designer does not give me the RunSavedImportExport command, and so I'm unable to select my import specification.
But I do have an import specification stored. And I know I need a macro. That's not a problem. I was hoping for a workaround since my macro designer does not give me the RunSavedImportExport command, and so I'm unable to select my import specification.
do the importing again, manually
when the Import wizard comes up
click on the advanced button
click on the Specs... button
find and copy the Import spec name that was saved
click cancel, cancel
when the Import wizard comes up
click on the advanced button
click on the Specs... button
find and copy the Import spec name that was saved
click cancel, cancel
ASKER
I gave that a try, but I don't have an Advanced button...
I'm using Access 2007. Are we in the same version?
I can create a new specification, no problem, but still no RunSavedImportExport command in macro designer. Do you know where it puts these spec files? If it's true that the spec has to be in a trusted folder, maybe Microsoft puts it in some weird place?
I'm using Access 2007. Are we in the same version?
I can create a new specification, no problem, but still no RunSavedImportExport command in macro designer. Do you know where it puts these spec files? If it's true that the spec has to be in a trusted folder, maybe Microsoft puts it in some weird place?
what type of project are working on? ADP, ACCDB?
if ADP, sorry that feature is not available
(RunSavedImportExport) look in the ribbon external data > saved??/
if ADP, sorry that feature is not available
(RunSavedImportExport) look in the ribbon external data > saved??/
ASKER
I'm not working in a project, just your basic MDB.
I can run the saved import specification from the ribbon, I just can't get to the command to run it from a macro. Too bad there's nothing simple like a switch in Scheduled Tasks which will let me run the specification directly.
I can run the saved import specification from the ribbon, I just can't get to the command to run it from a macro. Too bad there's nothing simple like a switch in Scheduled Tasks which will let me run the specification directly.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hey! That's the ticket! Thanks, man!
ASKER
Well, I was overly optimistic. I can access the command, but the database doesn't seem able to find the import specification...
I have not tried this as I don't have any files with import specs handy, but on the External Data tab, there is a "Saved Imports" item at the far left. If you click this, it opens a dialog which looks like it displays all of the saved import specifications. It also looks like you may have some ability to work with the spec from that dialog box.
ASKER
All is well. I recreated the import process using the "TransferSpreadsheet" action as noted in the other thread. Thanks again.
To do this in 2007, you need to make sure that this file (the mdb or accdb) is in one of your trusted locations. To add a directory as a trusted location you must:
1. Open Access
2. Click the Windows icon in the upper left corner
3. Click the Access Options at the bottom of the dialog
4. Click "Trust Center" on the left side of the "Access Options" dialog
5. Click the "Trust Center Settings" (middle right of the dialog) button
6. Click the Trusted Locations button
7. Fill in the appropriate boxes. Unfortunately, my work has disabled this feature so I cannot drill down any further.
7. Click the "Add new location"