RE: [PHP] excel 2 csv 2 mysql

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