By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,642 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,642 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Jul 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
be**********@yahoo.com.au (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
Jul 17 '05 #2

P: n/a
be**********@yahoo.com.au (TimGoogler) wrote in message
news:<69**************************@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
Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.