RE: [PHP] excel 2 csv 2 mysql

ok it works now /www_tools/apache/catdoc/bin/xls2csv -q 0 test.xls > test2.csv 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 then i can load that into mysql using load data into :D, aparantly there are some bugs , gotta find them >===== Original Message From daniel <daniel@electroteque.org> ===== >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 > > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php