Results 1 to 6 of 6
  1. #1
    klnlsu is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    107

    How do I run a saved Import routine automatically every time i open my database?


    I have saved an import routine that loads data from an Excel spreadsheet into a local table in my database. How do I run this routine automatically every time I open the database?

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,344
    Put it in the OnOpen event of the first screen(splash screen or switchboard) that opens in your db?

  3. #3
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Or create a macro called "AutoExec".

  4. #4
    klnlsu is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    107
    But what is the syntax? My saved import routine is called "Import-2016 Base Pricing". What function or command do I use to call this routine?

  5. #5
    klnlsu is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    107
    I found it...RunSavedImportExport:

    https://msdn.microsoft.com/en-us/lib.../ff834375.aspx

    Thanks.

  6. #6
    ssanfu is online now Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,869
    klnlsu,

    Thanks for letting us know your solution. I'm sure it will help someone in the future....
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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

Similar Threads

  1. Replies: 4
    Last Post: 02-12-2016, 12:31 PM
  2. Replies: 1
    Last Post: 10-29-2015, 07:03 AM
  3. Replies: 19
    Last Post: 08-28-2014, 01:13 AM
  4. Importing CSV file into 2010/creating save import routine
    By rbtrout in forum Import/Export Data
    Replies: 5
    Last Post: 08-05-2011, 08:54 AM
  5. Have database open automatically
    By Norman Masson in forum Access
    Replies: 6
    Last Post: 01-08-2008, 07:41 AM

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 - Senior Forums