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

's Computer Specifications

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?

's Computer Specifications

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

Cliff Edwards

's Computer Specifications

On Tue, 24 Jun 2008 10:35:13 -0700, ChuckM-SAT
<ChuckM-(E-Mail Removed)> wrote:

>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?

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

's Computer Specifications

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

"ChuckM-SAT" wrote:

> 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?

's Computer Specifications

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" wrote:

> compatability issue - i get same/similar issue when referencing data in excel
> 2003 with office 2007.
>
>
>
> "ChuckM-SAT" wrote:
>
> > 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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
compare two files and merge rows base on a matching word within thesetwo rows	mshak	Microsoft Excel Programming	1	9th Dec 2009 01:34 AM
Access counts blank rows in Excel rows as records in linked table	Linkerbink	Microsoft Access External Data	1	14th Nov 2009 05:37 PM
"Add/Remove Rows Code" adds rows on grouped sheets, but won't remove rows.	Conan Kelly	Microsoft Excel Programming	1	16th Nov 2007 10:41 PM
Copy rows of data (eliminating blank rows) from fixed layout	=?Utf-8?B?U3dlZXBlYQ==?=	Microsoft Excel Misc	1	13th Mar 2007 11:05 PM
DataGrid, Windows - Does not refresh. data is in the rows but they are not visible, the rows are solid blue	Richard	Microsoft C# .NET	1	2nd Sep 2005 01:56 PM