Web Hosting Talk







View Full Version : excel (csv) to mysql


iem
09-22-2002, 08:08 AM
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
09-22-2002, 08:18 AM
You can do this manually. If your host has phpMyAdmin (http://www.phpmyadmin.net/), you'll be able to import a database in CSV format. To get the CSV file, just generate it in Excel.

Alan