Re: excel 2 csv 2 mysql

The quotes are valid, use fgetcsv() function, it will strip them daniel wrote:

ok guys are you ready , /www_tools/apache/catdoc/bin/xls2csv test.xls > test2.csv gave me this "column1`","column2","column3" "faffafs","fsafsa","fsafs" "fssfa","fasfs","fasfs" "fasaf","fasfs","asffaf" "fafs","sfafsa","fasfas" "sfafs","fssfa","fassfa" "sfasfa","asfafs","fasfas" "asffas","sfaaf","sfafsa" "fssaf","asffsa","asffas" "sfasfa","sfasaf","fasasf" unfortunately its putting quotes in, have to strip them

===== Original Message From <jon@gokart4xmas.com> ===== Yeah... you're going to have to use COM or something similar on a windows server to get effective access to the server. Another option is dynamically adding at as an odbc datasource and querying it. Again, this will only work on a windows server... It's all much easier if you can convince users to upload csv files. - jon ------------- jon roig senior manager, online production epilepsy foundation http://jonroig.com -----Original Message----- From: daniel [mailto:daniel@electroteque.org] Sent: Monday, March 31, 2003 7:48 PM To: php-general@lists.php.net Subject: [PHP] excel 2 csv 2 mysql hi guys i am trying to work out how to dynamically be able to upload an excel file , export it to csv to be able to import into mysql , is there any examples out there ? fopen gave me binary code :| -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php