Solved

Where Is Microsoft Access RunSavedImportExport Command

Posted on 2010-07-09
1,128 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

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    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.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    678 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

    28 Experts available now in Live!

    Get 1:1 Help Now