mysqlexcelimport-from-excel

importing data into ALREADY CREATED mySQL database


PROBLEM: importing data into ALREADY CREATED mySQL database

I've done a lot of search online and know that I can import a CSV file into phpmyadmin in order for the table to be automatically created but I have created an empty table with the exact same fields as the CSV file but would like to just import the data itself.

The reason I don't want the import function to create the table for me is because I have created my table with certain restrictions/data types that arent correctly created when I do the import.

so basically, my question is, is there a way I can import data directly into an already created table (without having to manually write the 'INSERT INTO....' statements)?

Is there a piece of software that will convert spreadsheet data into an insert statement?

Thanks very much for your help! Theresa


Solution

  • You could give either of these a whirl:

    Navicat - http://www.navicat.com/en/products/navicat_mysql/mysql_overview.html

    or

    Heidi - http://www.heidisql.com/

    Navicat is a licensed product (i.e. paid for). Heidi is open source.

    EDIT: Forgot to mention that certainly within Navicat you can import from Excel to a pre-defined table.