MS Query Maximum return rows

G

Guest

I set a data source in EXCEL. Tried to bring data from SQL server database to
EXCEL. It works fine when less than 32768 records were returned. If the
recordset has more than 32768 rows, MS query only showed 32768 rows.

I did not check to restrict return rows. I want my 50000 records all
returned in MS query then it can be sent to EXCEL. Now It failed to me. Error
shows "Can't show all records".

My question is, does MS Query has a limited capacity to return query result?
If it does, what is it maximum return rows?

Any helps.

Thank you.
 

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

Help with MS Query in EXCEL 1
Excel linked to Access w/"Like" not working 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
SQL not importing records from ACCDB 2
Pass Through Query - not returning rows 1
group/sum in ms query 1
Query not returning all the rows 8
Run Query - return 10 rows 4

Top