Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  ASP.NET  Read CSV File into Database Table

Author  Topic  leezo Starting Member 9 Posts Posted - 2009-08-23 : 11:18:43 Hi, I need to read CSV files columns into my database table. I used several methods and failed. Can you please suggest a method to do that regardless of column datatypes. I used SQLBulkcopy by the way but had a problem store the row itemarray into my db because sqlbulkcopy reads one of the rows of datatype UNIQUEIDENTIFIER as string which caused error when copying it to the mapping row in the database.