Actions Catalog Pane Access 2007

[sbf2014]

Hi everyone,

I need to create a macro in access (my first one ever) that will automatically import roughly 50 excel spreadsheets. I have gathered that I need to use the ImportExportSpreadsheet action, found in the actions catalog pane, in order to do this.

However, I am driving myself crazy because I cannot find the actions catalog in Access 2007! It does not automatically open when I create a new macro.

Can someone please explain where the actions catalog pane is in Access 2007?

 

[pbaldy]

I don't use macros, but you should see a column titled Action with a drop down to choose the action. If all aren't shown, there's an icon on the ribbon titled "Show all Actions".

 

[sbf2014]

Thanks for the response!

I did click the 'Show All Actions' option and looked through the available actions in the drop down tab.

ImportExportSpreadsheet is still nowhere to be found.

Any other ideas?

 

[pbaldy]

I'm not familiar with that one. I suspect you're after TransferSpreadsheet.

 

[sbf2014]

That is very possible.

I was following this set of directions when I was looking for ImportExportSpreadsheet:

smallbusiness.chron.com/import-excel-spreadsheet-access-macro-42538.html

I'll try TransferSpreadsheet and see where I get.

Thank you!

 

[pbaldy]

Poking around, it looks like the Action Catalog is new with 2010, so that's why you're not seeing it. Hopefully the other directions work in 2007. I've always been a VBA guy, so not that familiar with macros.

 

[pbaldy]

I started up a VM with Access 2013, and indeed there is an Action Catalog and one of the actions is ImportExportSpreadsheet. Looks like your instructions were based on 2010 or 2013.

 

[sbf2014]

Update: I was able to import excel files using the TransferSpreadsheet action. Thank you so much!

 

[pbaldy]

Happy to help!