Results 1 to 2 of 2
Thread: excel (csv) to mysql
-
09-22-2002, 08:08 AM #1Junior Guru Wannabe
- Join Date
- Apr 2002
- Posts
- 33
excel (csv) to mysql
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
-
09-22-2002, 08:18 AM #2Web Hosting Master
- Join Date
- Aug 2001
- Location
- United kingdom
- Posts
- 1,003
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.
AlanAlan Ho
Former Systems Administrator