How do I get more rows than 66,000 rows?

C

ChuckM-SAT

When exporting from a query program [CyberQuery] to Excel 2007 I get an error
'truncated results' and only get 65536 rows. What happened to the 1,000,000
mentioned in 2007?
 
W

ward376

There may be a setting in your query program that limits the number of
records returned.

Cliff Edwards
 
R

Ron Rosenfeld

When exporting from a query program [CyberQuery] to Excel 2007 I get an error
'truncated results' and only get 65536 rows. What happened to the 1,000,000
mentioned in 2007?
Click to expand...

Perhaps somehow Excel 2007 thinks it is in "compatibility mode". I don't
believe this is user configurable, so there may be something in your query
program that is responsible.
--ron
 
J

jatman

compatability issue - i get same/similar issue when referencing data in excel
2003 with office 2007.
 
C

ChuckM-SAT

Did you ever get a solution --- I have had the query program parameters reset
so as not to be the problem on call-up the Excel version... still have the
issue.
chuck

jatman said:
compatability issue - i get same/similar issue when referencing data in excel
2003 with office 2007.



ChuckM-SAT said:
When exporting from a query program [CyberQuery] to Excel 2007 I get an error
'truncated results' and only get 65536 rows. What happened to the 1,000,000
mentioned in 2007?
Click to expand...
Click to expand...
 

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

Excel --> Word 4
How do i enable all 1,00,000+ rows in excel 2007 2
How can I print rows that go outside of the page without shrinking the text? 0
How to have more than 65,000 rows in excel 2007 2
more than 65536 rows 13
How to Update SUM formula after inserting rows 2
Need Help with a VBA subroutine 0
Additional Rows and Columns in Excel 2007 1

Top