Solved

Where Is Microsoft Access RunSavedImportExport Command

Posted on 2010-07-09
1,136 Views
Last Modified: 2013-11-27
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!
0
Question by:davewalter1
    13 Comments
     
    LVL 46

    Expert Comment

    by:Dale Fye (Access MVP)
    I'm assuming that you have an Access database, which contains a Autoexec macro, or startup form which is what will fire the import action, when run as a scheduled task.

    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"
    0
     

    Author Comment

    by:davewalter1
    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.
    0
     
    LVL 119

    Expert Comment

    by:Rey Obrero
    <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.

    0
     

    Author Comment

    by:davewalter1
    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.

    0
     
    LVL 119

    Expert Comment

    by:Rey Obrero
    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
    0
     

    Author Comment

    by:davewalter1
    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?
    0
     
    LVL 119

    Expert Comment

    by:Rey Obrero
    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??/
    0
     

    Author Comment

    by:davewalter1
    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.
    0
     
    LVL 46

    Accepted Solution

    by:
    I could not find Transferspreadsheet or TransferDatabase in the macro actions either.  Then I notice the "Show all Actions" button in the Macro Tools.  After clicking that button, the Transferspreadsheet and transfer database options were visible.
    0
     

    Author Comment

    by:davewalter1
    Hey! That's the ticket! Thanks, man!
    0
     

    Author Comment

    by:davewalter1
    Well, I was overly optimistic. I can access the command, but the database doesn't seem able to find the import specification...
    0
     
    LVL 46

    Expert Comment

    by:Dale Fye (Access MVP)
    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.
    0
     

    Author Comment

    by:davewalter1
    All is well. I recreated the import process using the "TransferSpreadsheet" action as noted in the other thread. Thanks again.
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone. Privacy Policy Terms of Use

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    875 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now