I need to export more than 160,000 lines in a csv file.
obj.Export "c:\Test.CSV" , "," , , TRUE (not work )
obj.ExportEx "c:\Test.XLS" (not work)
and i have error failed to write data to the file (after 30 mn of execution ).
Is there a function that distributes the rows retrieved on sheets of 65536 lines as does the XLS button?
Someone of you has an idea to export a table of this size to Excel or CSV File.
Thanks for your Help
Perhaps you instead could look into the requirements of the user, and try solving the problem by altering the task.
Is it really necessary to export that amount of rows?
Can the data be aggregated, making the number of rows smaller?
Which operations are performed in Excel, and can they be migrated to QV?
It's for this reason that we have implemented filter to reduce the volumetry and generate an Excel File for each case
I can export the result in a .txt file but it doesn't fit the need of the user.
The macro I have used before to export tables is this:
set obj = ActiveDocument.GetSheetObject("CH29")
It looks a bit different from yours, but wheter is has a performance diffence is unclear. You could give it a go, and let everyone know
With this statement we can have an Excel file with several Sheet.
This is valid for a certain volume of lignes. In my case (high volume) the generated file can not be read error (invalid format).This is the best solution I've tried.
You should know with such volumetry one csv file that exceeds 250MB and more than 160,000 lines notepad can not read.