Bulk update from .csv file

[kristof]

Hi,

I will need to process a .csv file, and use the data to update certain columns of existing records (of one table).

I expect the csv to have about 350K+ lines, so updating line per line, sending single update statements, would take ages.

Any ideas?

 

[AlexCuse]

If the database in question is SQL Server and you are using .net 2.0, then you could use SqlBulkCopy to get your .csv into a table, and then run an update query from there.

Otherwise, you will need to do row by row inserts to get the data in, so you may as well just do row by row updates.

Wrapping all your updates/inserts in a transaction should help a little bit.

Hope this helps,

Alex


[small]----signature below----[/small]
Now you can go where the people are one!
Now you can go where they get things done!