Query won't let me get more than 95 fields

B

Brian

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?
 
D

Debra Dalgleish

Choose Data>Import External Data>Import 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
 
B

Brian

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
 

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

"Fields Nested Too Deeply" Error in Simple Word Document 5
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Query of an Access database won't let me get more than 95 fields. 0
Clearing Fields in a Word Form 5
Using Access Database to build contracts with fields on pdf document 0
Adding data to MS Access from csv file 0
Report Group Footer DLookUp 0
Some mail merge fields not pulling into document 2

Top