Problem in Exporting a large number (65000 records) of data in .csv

Vasanth

I am having nearly more than 80 thousand records and i need to export in .csv format.

I need to export to woksheet.

I need to export nearly 65 thousands of records in one sheet,

When it reached the limit, it shuld exported in the next sheet.

Can any one please help me in this issue.

Mudassar

0 1

How are you exporting? And BTW CSV is a Text file it does not have limits

Vasanth

0 2

I am just exporting to the Excel in .CSV format.

Excel is limit to 65000 records.

Mudassar

0 3

But that's because you are opening it in Excel. If you open it with notepad it will not cause issue.

Secondly i would like to know how are you exporting?

Vasanth

0 4

I am using StreamWriter to write the string to the Excel.

I am implemeting this in Visual Studio 2003.

Vasanth

0 5

Is that possible to open a worksheet in vs 2003 and write contents dynamically in vs 2003.