if that process works for you. don't create a script, just use LOAD DATA INFILE. http://www.mysql.com/doc/en/LOAD_DATA.html jeff Jadiel Flores <jflores@abarg To: php-db@lists.php.net on.com> cc: Subject: Re: Excel to MySQL 05/09/2003 11:27 AM You could export your xls to csv and create a little script to read the values in the files and insert them into the DB. At 04:21 PM 5/9/2003 +0100, you wrote: >Hi, > >I have some data in an Excel spreadsheet that i need to uplaod to a MySQL >Database, is there any way to do this i.e. formatting each cell so there >qoutes around each entry, exporting to a text file etc > >Thanks for your help > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php Jadiel Flores ------------------------- http://www.abargon.com jflores@abargon.com (52-55) 52-29-80-34 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
