Store csv file in sql tqble

Question

Hi All I want to store a csv file in sql table can u help me please.. If I am using excel file except csv it is working fine.. But when I am using csv file it is throwing exception External table was not in correct format. Please help me Anish

Amit Choudhary · Answer

hi friend use following code to read text csv file and fetch the data into dataset: In this code The method GetMyCSVFileData() is used to read the .CSV file. This function read the Mycsvfile.txt file and store the data into the dataset. We can get the data from dataset. using System.Data; using System.IO; namespace ConsoleApplication1 { public class Program { static void Main(string[] args) { DataSet myDataSet = GetMyCSVFileData(); foreach (DataColumn MyDataColumn in myDataSet.Tables[MyDataTable].Columns) { Console.Write({0-20} MyDataColumn.ColumnName); } Console.WriteLine(); foreach (DataRow MyDataRow in myDataSet.Tables[MyDataTable].Rows) { foreach (DataColumn c in myDataSet.Tables[MyDataTable].Columns) { Console.Write({0-20} MyDataRow[c]); } Console.WriteLine(); } } private static DataSet GetMyCSVFileData() { string MystringLine; string[] MystringArray; char[] charArray = new char[] { '' }; DataSet MyDataSet = new DataSet(); DataTable MyDataTable = MyDataSet.Tables.Add(TheData); FileStream MyFileStrema = new FileStream(Mycsvfile.txt FileMode.Open); StreamReader MyStreamReader = new StreamReader(MyFileStrema); MystringLine = MyStreamReader.ReadLine(); MystringArray = MystringLine.Split(charArray); for (int i = 0; i { MyDataTable.Columns.Add(MystringArray[i].Trim()); } MystringLine = MyStreamReader.ReadLine(); while (MystringLine != null) { MystringArray = MystringLine.Split(charArray); DataRow dr = MyDataTable.NewRow(); for (int i = 0; i { dr[i] = MystringArray[i].Trim(); } MyDataTable.Rows.Add(dr); MystringLine = MyStreamReader.ReadLine(); } MyStreamReader.Close(); return MyDataSet; } } } please mark as answer if it helps.

Anish Khan · Answer

Hi Shusta You can't understand.... See Amit's post..... ------------- Anish

Anish Khan · Answer

Hi Amit Thanks for reply Your code are working fery fine............... I Used GetMyCSVFileData(){} function to read data and store it in to dataset. And after that I used SQLBulkCopy to store it into database table It's very usefull code. Thanks Again Anish

Sushta Guthnar · Answer

I am outside of saying of ctrl-c ctrl-v as i am not of the understanding Shusta

Sam Hobbs · Answer

I don't understand what you are using when you get the error. Are you trying to import using Excel and getting the error? What are you asking for help with? Are you trying to write a program to read a CSV file or do you need to use Excel? To write a program look at Using CSV and Other Delimited Files in C# .