Results 1 to 6 of 6

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

  1. #1
    klnlsu is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    89

    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,147
    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,579
    Or create a macro called "AutoExec".

  4. #4
    klnlsu is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    89
    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 Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    89
    I found it...RunSavedImportExport:

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

    Thanks.

  6. #6
    ssanfu is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    6,950
    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, 11:31 AM
  2. Replies: 1
    Last Post: 10-29-2015, 06:03 AM
  3. Replies: 19
    Last Post: 08-28-2014, 12: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, 07:54 AM
  5. Have database open automatically
    By Norman Masson in forum Access
    Replies: 6
    Last Post: 01-08-2008, 06: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
  •  
Tech Forums: Microsoft Office Forums