PDA

View Full Version : anyway to get contents of a .xls file into a mysql db ?

c q
09-14-2002, 06:16 PM
I have a huuuuuuge .xls file. Is there any shortcut method I can incorporate its contents into mySQL ?
....help ???
Spookster
09-14-2002, 06:59 PM
Use Excel to export it as a CSV file and then use phpMyAdmin if you have it to import it into MySQL.
c q
09-14-2002, 07:18 PM
emmm....what might be this phpMyadmin ?
Spookster
09-14-2002, 08:30 PM
It's an application written in php to administer MySQl databases

http://www.phpmyadmin.net/

Many web hosts provide it for you. If not you can download and install it yourself.
c q
09-15-2002, 06:11 AM
cannot find server or DNS err :eek:
but I also hit a google search and foound the same link...maybe some prob. with their server lol
sebastard
09-26-2002, 08:41 PM
http://phpmyadmin.sourceforge.net/