Access 2007 - New - Macros - Transfer Spreadsheet Action

[Paperback Writer]

I just got upgraded to Access 2007. I need to create a new macro. The
actions dropdown are very different. I don't see any options that will allow
me to transfer a spreadsheet (or any other kind of document) into the
database.

Is there a setting I need to change?

Thanks!

 

[Tom Wickerath]

Are you running your application in a trusted folder?

http://www.accessmvp.com/TWickerath/articles/trust.htm

See Jeff Conrad's article here, after trusting your application per the
above instructions:

http://accessjunkie.com/faq_02.aspx


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[boblarson]

There's a button on the macros ribbon that says SHOW ALL ACTIONS. Press it.

 

[Maurice]

When you choose create macro look in the macro ribbon and click on the "Show
all actions" button. That will show the actions which you need.

hth