transfer records from Ecxel to MySQL

Hi everyone.

I had export MS SQL records to an Excel file (via E.R.P. program). now i want all this records to transfer (import) in MySQL database. which is the right way to do this?

thanks in advance.

 

you could google it and find many converters available to do it automatically.

 

Hi, I found some answer try it I don't know yet if it works http://forums.mysql.com/read.php?79,1888,2313#msg-2313

 

Try Navicat: http://www.navicat.com/

It allows you to import into mysql from txt, excel and a bunch of other file types. They have a free trial and a free personal version.

 

Try using excel itself to generate the insert statements. I have done this several times. Using formulas in one of the cells i am generating insert for the first row of data then I am just copying the formula and then copying and pasting the whole column in notepad and you have insert script.

 

You can save the excel file as CSV format and import CSV file using many MySQL GUIs including phpmyadmin, heidisql etc. Or you can use MySQL's LOAD DATA INFILE syntax.

 

nice advice here lol i was about to ask more less the same thing

 

this is the best and easiest way to do it...

 

Here is the list of MySQL GUI tools which can help you to import data.

 

you could google it and find many converters available to do it automatically.

 

Navicat is the best. I am using it myself

 

I agree but but it is paid