With excel, export your exel file to CSV (by doing save as...) then you can import your CSV file to mysql using the phpmyadmin import interface On Tuesday 02 November 2004 04:11 am, Sejati Opreker wrote: > Yes, I'm planning to work with MySQL, but the problem > accour from the first time, 'cause the source is in > Excel file, is MySQL able to read the CVS format ?, > and can you please show me some PHP script that make > outputs the contents of report to a CSV from MySQL ? > > --- Ben Ramsey <lists@xxxxxxxxxxxxx> wrote: > > Matt M. wrote: > > >>Can PHP work with Excel files as database ? > > >>If not, how can I conver it to MySQL format and > > >>reconvert it to Excel 'coz I need it to report it > > >>in Excel format, > > > > > > if you are on windows you could use a com object. > > > > > > if you have access to perl, you could use > > http://search.cpan.org/~kwitknr/Spreadsheet-ParseExcel-0.2603/ParseExcel.pm > > > You could also just use the MySQL database and have > > a PHP script that > > outputs the contents of your report to a CSV > > (comma-separated value) > > file with an extension of .csv. Excel will > > automatically open these > > files without problem. > > > > -- > > Ben Ramsey > > Zend Certified Engineer > > http://benramsey.com > > > > --------------------------------------------------- > > Atlanta PHP - http://www.atlphp.org/ > > The Southeast's premier PHP community. > > --------------------------------------------------- > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > __________________________________ > Do you Yahoo!? > Check out the new Yahoo! Front Page. > www.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
