[Amaka123]

i really need an urgent help, stuck with writing cod to import csv file with double quote into sql server database, can someone help me am a newbie in programming

[MentalFloss]

If you're using Microsoft Sql Server, there's the data import tool. There's no programming required. You just have to map the file correctly to the correct columns.

[Amaka123]

I have use some of the tools like ssis, bulk insert, openrowset and they all give me errors resuling from the double quote complication in the CSv file. can u help me with codes to overcome the double quote and import the fie to sql server database

[JackOfAllTrades]

Moved to Databases.

Note no one's likely to hand you code, if that's what you're expecting.

[Amaka123]

The below is my code..can some one help me figure out why i cant upload the csv file;thanks

protected void Button1_Click(object sender, EventArgs e)
        {
            if (FileUpload1.HasFile)
            {
                FileInfo fileinfo = new FileInfo(FileUpload1.PostedFile.FileName);


                string strCsvFilePath = Server.MapPath("CSVFolder") + "\\" + fileinfo.Name;

                FileUpload1.SaveAs(strCsvFilePath);

                string strFilePath = Server.MapPath("CSVFolder");
                //DataTable csvTable = new DataTable("CSV_Data");
                SqlConnection dbConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnString"].ToString());
                StreamReader sr = new StreamReader(strCsvFilePath);
                string csvDataconnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strCsvFilePath + ";"
              + "Extended Properties=" + "'text;HDR=Yes;FMT=Delimited'";

                {


                    OleDbConnection con = new OleDbConnection(csvDataconnectionString);
                    OleDbCommand cmd = new OleDbCommand(string.Format
                                                  ("SELECT * FROM [{0}]", strFilePath), con);

                    con.Open();

                    // Using a DataReader to process the data
                    OleDbDataReader reader = cmd.ExecuteReader();
                    SqlBulkCopy bc = new SqlBulkCopy(dbConn);
                    bc.DestinationTableName = "CSV_Data";

                    //bc.BatchSize = csvTable.Rows.Count;

                    dbConn.Open();

                    while (reader.Read())
                    {
                        bc.WriteToServer(reader);
                    }

                    dbConn.Close();
                    bc.Close();
                }
            }
        }
    }
}

MOD EDIT: When posting code...USE CODE TAGS!!!

This post has been edited by JackOfAllTrades: 03 September 2010 - 04:38 AM
Reason for edit:: Added code tags

[JackOfAllTrades]

OK, now we have code, so I guess I'll move this to C#.

Please tell us what exactly is the problem you are having...any errors? How does the result differ from what you expect?

[Ionut]

Quote

they all give me errors resuling from the double quote complication in the CSv file

Can you give an example of such complication? Can you attach the CSV file?