Lagzy
asked on
More Microsoft Query Columns
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the answer. I will give it a try this weekend.
ASKER
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.
Thank you Laqzy. I am glad I could help. :o)