Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : excel (csv) to mysql

[iem]

hello,

i have some excel files that i need to upload to mysql tables. i did a search to look for tools. the ones i found are listed below. i'd like to know if anyone has used any of them and if so, what you thought.

free
http://www.hotscripts.com/Detailed/17912.html

not free
http://www.convert-in.com/xls2sql.htm

http://www.mysqlstudio.com/product.php3

thanks
indera

[ho247]

You can do this manually. If your host has phpMyAdmin, you'll be able to import a database in CSV format. To get the CSV file, just generate it in Excel.

Alan