Bulk insert from csv to mysql

Question

4.00/5 (1 vote)

See more:

C#

MySqlBulkLoader bl = new MySqlBulkLoader(conn);
          bl.TableName = "blancco";
          bl.FieldTerminator = ",";
          bl.LineTerminator = "\n";
          bl.FileName = file;

          try
          {
              Console.WriteLine("Connecting to MySQL...");
              conn.Open();

              // Upload data from file
              int count = bl.Load();
              Console.WriteLine(count + " lines uploaded.");

              conn.Close();
              Console.ReadLine();
          }
          catch (Exception ex)
          {
              Console.WriteLine(ex.ToString());
              Console.ReadLine();
          }
          Console.WriteLine("Done.");
          Console.ReadLine();
      }

Hello,

I have a problem with inserting data from csv file to mysql,the problem is that the date is enclosed in double quotation and when I remove quotation all gets miss aligned any sugestions please as I am struggling for couple days now.

Thank you

Posted 13-Apr-15 0:12am

SyAndroidDog

Add a Solution

Comments

Nathan Minier 13-Apr-15 8:05am

Your code snipped doesn't show the MySqlBulkLoader.Load(), which is needed at a minimum to see how you're parsing the csv.

Sinisa Hajnal 14-Apr-15 3:29am

Why does it get misaligned? The date does not contain comma it shouldn't affect field ordering.

BulletVictim 14-Apr-15 4:41am

Try ading the csv data to a DataTable in your code and the BulkCopy the datatadble into SQL

SyAndroidDog 15-Apr-15 7:38am

solved use load infile etc

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 10572607 · Accepted Answer · 2015-06-29T19:43:00

C#

using (CsvDataReader csvData = new CsvDataReader(path, ',', Encoding.UTF8))
    {
        // will read in first record as a header row and
        // name columns based on the values in the header row
        csvData.Settings.HasHeaders = true;

        csvData.Columns.Add("nvarchar");
        csvData.Columns.Add("float"); // etc.

        using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
        {
            bulkCopy.DestinationTableName = "DestinationTable";
            bulkCopy.BulkCopyTimeout = 3600;

            // Optionally, you can declare columnmappings using the bulkCopy.ColumnMappings property

            bulkCopy.WriteToServer(csvData);
        }
    }