<div>
Why don't you use multiple queries? &nbsp;If you have a unique identifier for each record, you can hide it (to avoid repetition). &nbsp;You can write a small VB macro to refresh these queries.
</div>


Why don't you use multiple queries?  If you have a unique identifier for each record, you can hide it (to avoid repetition).  You can write a small VB macro to refresh these queries.

<div>
Thank you for the answer. &nbsp;I will give it a try this weekend.
</div>


Thank you for the answer.  I will give it a try this weekend.

<div>
To yu108352: &nbsp;I have tried multiple queries. &nbsp;And while they work OK enough in Excel 97, they seem to cause problems in Excel 2000 and want to have a system that will avoid problems in both 97 &amp;&nbsp;2000. &nbsp;Thank you anyway.
</div>


To yu108352:  I have tried multiple queries.  And while they work OK enough in Excel 97, they seem to cause problems in Excel 2000 and want to have a system that will avoid problems in both 97 & 2000.  Thank you anyway.

<div>
Thank you Laqzy. &nbsp;I am glad I could help. &nbsp;:o)<br />

</div>


Thank you Laqzy.  I am glad I could help.  :o)


<div>
<div class="content wysiwyg-content">
Using microsoft Query (wizard) on Excel 97/2000, how can I make a query with 200+ columns/fields (I'm brining in information from Access)? &nbsp;Currently, every time I try to bring over 85-90 columns/fields from Access into Excel the query never happens. &nbsp;And I need over 200 columns brought over at once. &nbsp; 
</div>
</div>


Using microsoft Query (wizard) on Excel 97/2000, how can I make a query with 200+ columns/fields (I'm brining in information from Access)?  Currently, every time I try to bring over 85-90 columns/fields from Access into Excel the query never happens.  And I need over 200 columns brought over at once.   

More Microsoft Query Columns

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.