Getting data from excel to php (or to html)

[sublimdun]

hi, I am very new to PHP and I'm wondering if it is possible to take data that is in a microsoft excel file onto a web page, the link that I believe would be the easiest would be to connect using php, but since I do not want to write new data back to excel do i have to use CSV files? Please offer any suggestions to the easiest solution. Thank you for your time.
~Rachel

 

[sleipnir214]

Depends. On what are you running PHP?

If you're running PHP on a Win32 OS, you can use ODBC to access the data directly.

On a non-Win32 box, you'll probably have to export the Excel data.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sublimdun]

I am writing the code on a win32 OS but does it matter if my web server is not a win32 system, it would right?
If so would exporting to mySQL be the best option?

~Rachel

 

[sleipnir214]

First answer:
Yes, it matters that your web server is not Win32.


Second answer:
Maybe. I recommend that you pass the data to a database server. Whether MySQL is the best one for your purposes, I can't answer.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!