Run Multiple Imports At Once?

[GreenWizard]

I have about 10 saved Imports in my Microsoft 2013 Access Database. Is there a way to run them all, instead of having to select an individual import > Clicking Run > Then Clicking Ok > Then selecting the next import?

Much appreciated!

 

[Joe4]

You can run them all at once with a macro (just create multiple macro actions, one for each import).
See: https://msdn.microsoft.com/en-us/library/bb177446(v=office.12).aspx

If you do not see the RunSavedImportExport action, click on the Show All Actions button from the Show/Hide ribbon.

 

[GreenWizard]

Thanks, but how do I create a macro in Access. I'm familiar with Macro's in excel. Usually I just record a macro, then run it. If need be I clean up the code in VBA.

Thanks again!!

 

[Joe4]

Just go to the Create menu and select "Macro" from the Other ribbon.

Note if you go to YouTube and type in "Create Macro in Access", there are lots of tutorials on it. It is different than Excel (you aren't recording anything), but it is very easy. You are just selecting some actions to run.