Transfer Spreadsheet in Access 2007

  • Thread starter Thread starter Michelle
  • Start date Start date
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
 
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.
 
Back
Top