Query a CSV file with ADO.NET and Restriction

  • Thread starter Thread starter Shiplu
  • Start date Start date
S

Shiplu

hi,
I am a newbie in this group.
pardon any mistake.
I am using ADO.NET to query a CSV file.
my CSV file has a Schema.ini file also.

Excel supprots 65535 rows. thats why I switched to CSV. is there any
restriction here.
I have to handle 3,600,000 rows at least
Thank you
 
I'm not aware of a restriction.
I seen > 100MB files.

Though, CSV is a hopeless 'format' it depends on the reader if it can read a
set like that.
Therefore using OLEDB might be the best for reading (and writting)
(forward only recordset)
 
I would import your CSV to a SQL Express (or SQL Everywhere) database. This
is far easier and considerably faster. The SqlBulkCopy class can do this.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top