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
[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
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
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
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
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]
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
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...)
8 matches
Mail list logo