RE: Text from Excel csv file loaded into MySQL table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello, 

> > Can anyone point me to a really good end to end tutorial on 
> extracting 
> > text from an Excel csv file and uploading it into MySQL via a PHP 
> > script?
> 
> Actually, depending on the integrity of the data and the 
> consistency of the format in the CSV file, you can do this 
> simply and easily using just MySQL.  Take a look at the 
> following pages:
> 
> MySQL >= 5.0
> http://dev.mysql.com/doc/refman/5.0/en/load-data.html
> 
> MySQL < 5.0
> http://dev.mysql.com/doc/refman/4.1/en/load-data.html

If the above is not an option for you, then use this:

http://us2.php.net/fgetcsv

Works like a charm.

-K. Bear

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux