Change the query so it returns 5000 records or so at a time. Then copy/paste that.
If there's a numeric field, you might be able to select on value (< 100, >=100 < 200, >=200) to make three query. Same idea for a text field or a date.
You might also try to export the complete big file to another format (say, csv or dbf or txt, I can't see here what MS Query supports) and import that in Excel. It might just work.
Hope this helps.
I'm using MS query (office 2000) to retrieve information from a Genesis database. The preview pane in query shows all the data (6 fields, a mixture of text and integer) correctly.
With a small number of matches, it's possible to copy and paste the data into an excel spreadsheet and all of it is displayed correctly - no problem.
The problem arises when a large number of matches are found (approx. 10,000 - is that large in comparison? I'm not that experienced in these matters!) to the query. Trying to copy and paste this number of matches causes both programs to freeze.
In this case the only option I can see is to run the query and export the data to an excel sheet, besides, in all cases this would be preferable due to the ease of refreshing the query.
When I try to do this, the data is all returned to excel correctly except for one text field which in all instances is represented by square boxes and chinese characters.
I'm thinking the problem must be between the communication between query and excel as I can see the data correctly in query, and copy/pasting a small number of matches into excel results in succesful displaying of all the data.
I hope this clearly explains the problem, any help much appreciated,