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?
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?
Put it in the OnOpen event of the first screen(splash screen or switchboard) that opens in your db?
Or create a macro called "AutoExec".
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?
I found it...RunSavedImportExport:
https://msdn.microsoft.com/en-us/lib.../ff834375.aspx
Thanks.
klnlsu,
Thanks for letting us know your solution. I'm sure it will help someone in the future....