Where Is Microsoft Access RunSavedImportExport Command

    Question by:
    On

    Topics:

    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!
    Good Question?
    0
     

    ?

    The member who asked this question verified this comment provided the solution that solved their problem.

    Accepted Solution on 2010-07-09 at 10:32:58ID: 33173186

    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.

    Top Expert Contributor

    Essential articles and videos from the Experts

    More valuable questions with Expert answers

    201511-LO-Qu-074

    Extend your technology team with the Experts Exchange community.

    — trusted by —

    Who answers my questions?Our community has technology experts around the world.

    Rey Obrero

    Expert in:

    • MS Access
    • Query Syntax
    • Visual Basic Classic
    • Databases
    • MS Applications

    Gustav Brock

    9

    Articles

    Expert in:

    • MS Access
    • Query Syntax
    • Databases
    • Visual Basic Classic
    • .NET Programming

    Dale Fye (Access MVP)

    9

    Articles

    Expert in:

    • MS Access
    • Query Syntax
    • MS Applications
    • MS Development
    • MS Office

    Jim Dettman (Microsoft MVP/ EE MVE)

    7

    Articles

    Expert in:

    • MS Access
    • MS Applications
    • Databases
    • MS Development
    • MS Office

    PatHartman

    Expert in:

    • MS Access
    • Databases
    • MS Applications
    • MS Excel
    • MS Office

    crystal (strive4peace)

    Expert in:

    • MS Access
    • MS Excel

    Nick67

    8

    Articles

    Expert in:

    • MS Access
    • MS Applications
    • MS Development
    • MS Excel
    • MS Office

    GrahamSkan

    3

    Articles

    Expert in:

    • MS Word
    • Visual Basic Classic
    • MS Office
    • MS Access
    • MS Applications

    ste5an

    Expert in:

    • MS SQL Server
    • MS SQL Server 2008
    • .NET Programming
    • C#
    • Databases

    RELATED TOPICS view all topics

    1. Query Syntax
      (46,071)
    2. Visual Basic Classic
      (162,808)
    3. MS Applications
      (44,139)
    4. Databases
      (52,982)
    5. MS Excel
      (125,078)
    6. MS Office
      (55,897)
    7. MS SQL Server
      (154,632)
    8. MS Development
      (48,689)
    9. VB Script
      (35,476)
    10. MS SQL Server 2005
      (71,583)