How to export Cursor/Table to Excel which are exceeding more than 65k rows 1

[Saif_Abc]

Hi,

Please refer to the above mentioned subject, I want to export into excel a table which has 170,421 records.

Thanks

Saif

 

[pjw001]

Which version of Excel are you using?

How are you trying to do it?

What error message are you getting?

 

[Saif_Abc]

Office 365

Thanks

Saif

 

[pjw001]

How are you trying to do it?

What error message are you getting?

 

[Saif_Abc]

Hi,

There is no error message, only it is truncating the records which are more than 65k.

Thanks
Saif

 

[pjw001]

Are you able to output the data to a csv file and then import that to Excel?

This might pinpoint where the problem lies.

 

[Chris Miller]

64k (65536) is a limit of the formats VFP exports via COPY TO and EXPORT.
I think pjw001's question is a solution, as you can write out longer csv files.



Chriss

 

[Saif_Abc]

Thanks PJW001 it is done.

I converted into CSV and done.

Thanks

Saif

 

[pjw001]

Thank you for the feedback Saif. Glad to be of help.