Multiple sheets in an excel file

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,
 
A

Arvin Meyer [MVP]

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.
 

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

Counting multiple memberships 1
Email individual sheets from an excel file 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
transfering text file 1
Import multiple Excel sheets 3
How to Create Multiple Sheets in an Output File 1
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
multiple sheets when importing into excel 1

Top