Is PHP able to extract data out of an Excel spreadsheet?

[TimGoogler]

The only form of database we use is an Excel database.
Otherwise is it possible to import the relevant spreadsheet data
into say MySQL?
Perhaps it is possible but does anyone know how or point me
in the right direction.
Thanks.
TG

[Matthias Esken]

[email]beagles_1881@yahoo.com.au[/email] (TimGoogler) schrieb:

> The only form of database we use is an Excel database.

There are ODBC drivers for Excel and you can access ODBC from PHP.

Regards,
Matthias

[Nikolai Chuvakhin]

[email]beagles_1881@yahoo.com.au[/email] (TimGoogler) wrote in message
news:<69c2c721.0310212245.209620bf@posting.google. com>...

>
> The only form of database we use is an Excel database.
> Otherwise is it possible to import the relevant spreadsheet data
> into say MySQL?

Sure. Save your Excel file as CSV and import it into MySQL using
LOAD DATA INFILE query.

Cheers,
NC