Re: [PHP] PHP Working With Excel File ?

2004-11-03 Thread p80
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

RE: [PHP] PHP Working With Excel File ?

2004-11-03 Thread Jay Blanchard
[snip] 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 [/snip] http://search.cpan.org/src/JMCNAMARA/Spreadsheet-WriteExcel-0.37/WriteEx cel/doc/WriteExcel.html There is a PHP version -- PHP General

Re: [PHP] PHP Working With Excel File ?

2004-11-01 Thread Matt M.
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

Re: [PHP] PHP Working With Excel File ?

2004-11-01 Thread Ben Ramsey
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

Re: [PHP] PHP Working With Excel File ?

2004-11-01 Thread Erich Kolb
I think the easiest way is to store your data in MySQL and then create a DSN via MyODBC and connect to your spreadsheet. Matt M. [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Can PHP work with Excel files as database ? If not, how can I conver it to MySQL format and reconvert it

Re: [PHP] PHP Working With Excel File ?

2004-11-01 Thread Sejati Opreker
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 [EMAIL PROTECTED]

Re: [PHP] PHP Working With Excel File ?

2004-10-31 Thread p80
On Monday 01 November 2004 02:58 am, Sejati Opreker wrote: Hi, 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, With exel, export your exel file to CSV (by doing save as...) then you

Re: [PHP] PHP Working With Excel File ?

2004-10-31 Thread p80
On Monday 01 November 2004 02:58 am, Sejati Opreker wrote: Hi, 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, Thx With exel, export your exel file to CSV (by doing save as...)