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