Access - Form Button to Run a "External Data" Saved Import from Excel

Posted on 2012-08-26
Last Modified: 2012-08-26
Hi All

I have asked a similar question to this regarding automating the import of a Text File.  During that automation the procedure in the setup of the Appending from a Text File had a different button in the setting up of that Saved Import file.  I don't see that same button when I am setting up an Append using the "External Data""Excel" wizard in A2007.

I have a Saved Import called "Import-TrialBalanceToTempTable" in the Manage Data Tasks window of A2007 that imports some data from Excel.  Instead of having to always open that I want to put that function on an Access Form using a Control Button to execute.  Is there a way to do that??
Question by:wlwebb
    LVL 39

    Accepted Solution

    Try this:
    DoCmd.RunSavedImportExport "Import-TrialBalanceToTempTable"

    Author Closing Comment

    WONDERFUL!  Thank you

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    754 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

    24 Experts available now in Live!

    Get 1:1 Help Now