Transfer Spreadsheet in Access 2007

M

Michelle

I created an Access DB in 2003 and have since upgraded to the 2007. I have
noticed that the Transfer Spreadsheet option is not there when creating a new
macro in 2007. But the DB's that I have done in 2003 have the Transfer
Spreadsheet still there with a little yield sign and exclamation point next
to it. Is this not available in 2007 and if it is, what it the new command
name? If it isn't then how would I automatically pull excel files into
Access?

Thanks in advance,
Michelle
 
J

Jerry Whittle

It's there, but it's hidden. I just ran into this one last week. For some
reason, Microsoft decided to hide some of the lessor used Actions. You should
see a Show All Actions button up on the Ribbon when you are in design view of
the macro. Click it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 - New - Macros - Transfer Spreadsheet Action 3
RTF data from Excel 2007 to Access 2007 1
Transfer Spreadsheet Question 6
XLS Spreadsheet Import to Access 2007 being rearranged 5
transfer spreadsheet 3
Transfer spreadsheet 1
Exporting Data from Access To Excel 10
export 1 record selection in Access database to Excel spreadsheet 1

Top