Multiple sheets in an excel file

  • Thread starter Thread starter Meg
  • Start date Start date
M

Meg

I have several Excel ('07) spreadsheets I use for tracking clients. Each one
has multiple (60 or more) sheets. I need to analyze or search for certain
cells and conditions. I've tried to import the file into Access, but it gets
"stuck" (for lack of a better way to put it) on the first sheet. Do I need
to completely redo my excel files so Access can interpret them? Can I prep a
macro in Excel to harvest the data instead?

Thanks in advance,
 
Access can import 1 sheet at a time. You may be able to write some code to
loop through the import process, importing them automatically, but they
would need to have the exact same structure or it would create an error.
 
Back
Top