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/