ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Query of an Access database won't let me get more than 95 fields. (https://www.excelbanter.com/excel-discussion-misc-queries/130331-query-access-database-wont-let-me-get-more-than-95-fields.html)

Brian

Query of an Access database won't let me get more than 95 fields.
 
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)?



All times are GMT +1. The time now is 05:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com