Export table to Excel or .CSV

[#1]

Hi All,

I am trying to export this huge table (about 100 columns and 37,000 rows)  as a .csv file. When I export to Excel, I get a message "Communication lost, closing document" and sometimes it downloads but then is missing about 25 rows. I cannot export as a csv at all. How can I export this table?

I was also wondering if the STORE function is only used for QVDs or can it be used to store the table to a regular Excel or .csv file? I tried it but the file is corrupted and doesn't open. It does create a file though.

Thank you.

[#2 · Accepted solution]

Hi you can store it as csv just like how you would store a qvd. Attached is an example.

Store Table into Table.csv(txt) ;

[#3]

Thank you so much for the solution and the example file. I had a syntax error in the Store. Thanks again.