The easiest way to turn excel into MySQL is to have excel save the file as a .csv (comma separated values) file and use the mysqlimport utility or a load data infile query to insert it into a table in MySQL.
-Eric On Tue, 7 Dec 2004 16:02:23 -0800, David Ziggy Lubowa <[EMAIL PROTECTED]> wrote: > > Hey guys , > > i know this has been discussed but looking through the archives i have more > less hit a stand still , i have one big excel file which has data i would > like to extract., Now i am no expert in perl neither am i in php , i have > looked at some tools like navicat but i dont see where you actually start the > app , if that is what happens. Any help is highly appreciated. > > cheers > > -Z > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] http://www.bleated.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
