Question

  • Creator
    Topic
  • #2227443

    import excel to mysql

    Locked

    by arjun_goud ·

    how to import excel to mysql in c#, using windows application.

All Answers

  • Author
    Replies
    • #2477970

      Clarifications

      by arjun_goud ·

      In reply to import excel to mysql

      Clarifications

    • #2477963

      first things first

      by thumbsup2 ·

      In reply to import excel to mysql

      First, export the excel spreadsheet to a comma separated text file (DOS CSV). Then use Notepad to open the file and make sure there are no quotes (single ‘ or double “) in the file, since those will mess up the import into MySQL. Don’t mess with the lines otherwise.

      After that, you need to create SQL statements to import the data (insert) into the database table.

Viewing 1 reply thread