Help with MS Query in EXCEL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to pull data from SQL server to EXCEL by using MS QUery. When a
small size data is pulled, it worked fine(say less than 30000 rows). When a
large size data is pulled, it always showed 32768 rows. Error msg: Can't show
all record.

I did not check off- to restrict return rows, Why it failed to me?

Does MS Query has a limited capacity to show data in its panel? I know if I
load the data Excel, Excel only take about 65000 rows.

Is anyone be able to let me know how i can get all my original data (67000)
to be returned to MS Query? Or is it possible or not?

Thank you.
 
I think you should post this question to one of the relevant Excel
newsgroups.

This newsgroup is for Microsoft Access, a database application. We do use
Queries but these are Access Queries, not MS Query.
 
Back
Top