ms Excel to MySQL Import Problems

Ive been trying to export a ms excel file into my SQL Database without success!

I export to text file or CSV within ms excel & upload to my db table, however it sticks all the data into the first field.

My excel file has 4 columns & my db table has 4 fields, city, state, people & airport.

Ive googled & tried different things but all imports to the first field aka city.

Any advice or help to make it import correctly? I have over 3,800 lines of info to add & manually adding them using the admin page on my site isnt an option

thanks

 

Try navicat. You can import from a bunch of different file types.

They have a free 30 day trial, and a lite version for non-commercial usage. The lite version is really only missing some of the more advanced reporting, backups, and scripting.

http://navicat.com/download.html

 

use sql...
program(C#,PHP,JSP...) to read excel data and then makes up sql.

 

Thanks, worked perfectly

 

Try DBConvert tool at http://dbconvert.com/convert-excel-to-mysql-pro.php

Data Selector allows users to select definite range of data to be converted. AutoSelection feature is able to automatically recognize tables for conversion....

 

if you still cannot find the tool and its a worst case, you can make the query with the excel formula to concat the field into sql insert statement then copy and execute on phpmyadmin.., i think phpmyadmin can execute more than 500 line on a time..

 

You can also use my service.
http://forums.digitalpoint.com/showthread.php?t=1722522#post13762550