How to copy data to XLS for more than 65536 records...(with formats)??

[agit72]

I have a data wich contains about 500.000 records.
How can i copy to XLS in a whole big file... while xls only contains 65.536 rows

 

[Mike Gagnon]

agit72

Although faq184-2617 refers to an older version of VFP and Excel, you may try the suggestion to see if that helps.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[jspellman]

agit72,

**********************
*procedure reccount
************************
procedure reccount

use (filename)
go bott
store recno() to m.reccount
if m.reccount >= 16,382
copy to file (filename).csv &&EXCEL WILL ONLY OPEN 65536 RECORDS
else
copy file to (filename).xls type xl5
endif
end proc

 

[fluteplr]

You can't.

XLS files can only handle 65536 rows.

So no matter what you do you are not going to be able to get 500,000 rows into an xls spreadsheet.

You could try copying to a CSV file (comma separated values) which van be any length but obviously you are going to lose any formating and I suspect Excel will still only read the first 65,536 records.

 

[jspellman]

You could set up a use dsn on the machine and link excel to it that way. I currently use this option for a 300k record file from dbase to excel.

Then I analyze it in a pivot table.

>data>pivot table> external data source.

John