Results 1 to 2 of 2
  1. #1
    Ant_Snell is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Jul 2021
    Location
    UK
    Posts
    34

    Macro to run saved imports

    I have 3 saved Imports in the “Manage Data Tasks” dialog box. I would like to run each one of these sequentially using an action button on a form rather than asking the user to open the Manage Data Task dialog. What Macro (preferably) or code can I use to run these saved imports please?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,300
    DoCmd.TransferSpreadsheet or DoCmd.TransferText. Code goes in button click event.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Saved Imports with Changing File Names
    By Johnny12 in forum Access
    Replies: 7
    Last Post: 06-10-2021, 04:41 PM
  2. Databases/Queries associated with Saved Imports/Exports
    By moody6086 in forum Import/Export Data
    Replies: 1
    Last Post: 08-16-2019, 09:06 AM
  3. pass paramaters to query in saved imports
    By nirvana in forum Import/Export Data
    Replies: 9
    Last Post: 03-15-2013, 07:58 AM
  4. Changing File Location in saved imports using VBA
    By akshatagarwal93 in forum Import/Export Data
    Replies: 3
    Last Post: 07-23-2012, 10:47 AM
  5. Access 2010 Saved Imports
    By Tomfernandez1 in forum Access
    Replies: 1
    Last Post: 09-27-2011, 12:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums