Debra,

Thank you. Can this method be automated. I was using a Query with automatic
refresh so when I open the file, it goes and gets the data. I thought with
the method you suggested, the process would be manual. Any thoughts?

Brian

"Debra Dalgleish" wrote:

Choose DataImport External DataImport Data
Locate and select your database, then click Open
Select a table or query, then click OK
Select a starting cell for the data, click OK

Brian wrote:
I need to import 100+ fields but the query I created of an Access database
won't seem to let me get more than 95 fields. I can break it up but would
like to keep it simple by getting all the fields in 1 query.

Is there a way to bring in 100+ fields in an excel query of an access
database?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html