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

  • Thread starter Thread starter ChuckM-SAT
  • Start date Start date
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?
 
There may be a setting in your query program that limits the number of
records returned.

Cliff Edwards
 
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
 
compatability issue - i get same/similar issue when referencing data in excel
2003 with office 2007.
 
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...
 
Back
Top