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

    Featured Post

     Java Android Coding Bundle

    Whether you're an Apple user or Android addict, learning to code for the Android platform is an extremely valuable, in-demand skill. It all starts with Java, the language behind the apps and games that make Android the top platform it is today.

    Top Expert Contributor

    Essential articles and videos from the Experts

    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…
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
    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.

    More valuable questions with Expert answers

    Question: I am trying to set a Public/Global variable in one form and then retrieve it in another form but I fail to do it right. Here is some of my code: '*** At the first form: Option Compare Database Public GBL_SubNum As Integer Public...

    Answer: try using the TempVars collection, no need to declare the variable Public Sub getGlobal() MsgBox "getting global" Tempvars!GBL_VisitNum = [Forms]![frmselectvisit].[Vnum].Value ' GBL_VisitNum = Me!Vnum ' I tried this way too MsgBox...

    Question: Heyas, When using SQL Server Migration Assistant to Migrate an Access DB to SQL Server 2008. I get the following error please see attached. I am using the wizard to migrate so I am selecting a MDB. Any help is welcome. Thank you.

    Answer: Which version of MS Access are you using? Here you can find more details regarding using SSMA to migrate Access to SQL Server. Refer the following blog. ...

    Question: I have a query that is exported into Excel from Access every morning. The file is exported into an Excel file with the same file name except it has the current date in the file name. For example today's file name is "Backorder Report -...

    Answer: I don't know if there is a WEEKDAY equivalent in Access VBA In Excel VBA you can do the following: (CODE) The second argument dictates which day of the week is day 1. In this case testing for Weekday being 2 would check for Date being a...

    Question: I have the following data: ID Name Indicator 23 John 43 Mike X 50 John X 12 Sue X 14 Joe 76 Sally 34 Joe 55 John X By doing a query (select name, count(ID), indicator from TABLE group by name, indicator) I am able to get...

    Answer:  what about this select name, count(ID) , case when min(indicator) = max(indicator) then min(indicator) else '^' end indicator from TABLE group by name

    201601-LO-Qu-076

    Extend your technology team with the Experts Exchange community.

    — trusted by —

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

    PatHartman

    1,526

    Solutions

    Expert in:

    • MS Access
    • VBA
    • Databases-Other
    • MS Applications
    • MS Development-Other

    Jim Dettman (Microsoft MVP/ EE MVE)

    7

    Articles

    5,569

    Solutions

    Expert in:

    • MS Access
    • MS Applications
    • Databases-Other
    • MS Development-Other
    • MS Office

    Rey Obrero

    18,767

    Solutions

    Expert in:

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

    Scott McDaniel (Microsoft Access MVP - EE MVE )

    11,300

    Solutions

    Expert in:

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

    Guy Hengel [angelIII / a3]

    11

    Articles

    37,333

    Solutions

    Expert in:

    • MS SQL Server
    • MS SQL Server 2005
    • Databases-Other
    • MS SQL Server 2008
    • MySQL Server

    als315

    1

    Articles

    2,096

    Solutions

    Expert in:

    • MS Access
    • MS Excel
    • MS Applications
    • MS Office
    • Query Syntax

    ste5an

    1,230

    Solutions

    Expert in:

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

    Helen_Feddema

    1

    Articles

    1,481

    Solutions

    Expert in:

    • MS Access
    • Outlook
    • MS Applications
    • MS Development-Other
    • MS Excel

    Nick67

    9

    Articles

    878

    Solutions

    Expert in:

    • MS Access
    • VBA
    • MS Applications
    • MS Development-Other
    • MS Excel

    RELATED TOPICS view all topics

    1. Query Syntax
      (46,849)
    2. Visual Basic Classic
      (163,326)
    3. MS Applications
      (43,061)
    4. Databases-Other
      (53,227)
    5. MS Excel
      (127,133)
    6. MS Office
      (56,517)
    7. MS SQL Server
      (155,366)
    8. MS Development-Other
      (47,892)
    9. VB Script
      (35,971)
    10. MS SQL Server 2005
      (71,260)