Query of an Access database won't let me get more than 95 fields.

B

Brian

I created a query of an Access database and I need 100+ fields to be
imported. I can break up the query into 2 seperate queries but would like to
keep it simple by bringing it all in with one query.

Is there some other problem or is this a limit set up by default in Excel?
Can I increase the number of fields I can import at one time?

Any other simple solution(s)?
 

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

Query won't let me get more than 95 fields 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Some mail merge fields not pulling into document 2
Slicers and Calculated Items in Pivot Table 2
Too few parameters 1
Using "like" query from and external link to Access 1
Complex Count Query 0
Import Data from Access query 8

Top