>From Excel, save the file as a CSV (comma separated values) use either mysql load data infile in an insert query or use phpmyadmin to import the csv into a table in your database.
Regards Assey On Tue, 7 Dec 2004, David Ziggy Lubowa 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
