View Single Post
  #1  
Old September 15th, 2011, 08:51 PM
Jeff Monroe Jeff Monroe is offline
Member
 
First recorded activity by OfficeFrustration: May 2006
Location: San Diego, CA
Posts: 27
Default Import Excel Worksheet Macro

I am trying to import a specific excel worksheet into Access 7 creating its own table via a macro.

The spreadsheet has several worksheets so I need specify a particular sheet. I cannot find the option in the macro builder. It only allows ranges.

Any ideas?

Thanks.

JM
__________________
jm