Posted by Roman Ziak on 04/02/06 06:57

Rainman wrote:
> I want to allow authenticated users to be able to use my PHP web page to
> upload their Excel spreadsheet data into specific columns of my MySQL
> table. I found "Spreadsheet_Excel_Writer", but I want to go the other
> way, so I don't think this would be useful. I am rather lost how to go
> about this endeavor. Can someone drop me a few hints?
>
> Mark

If you are running on Windows server, you can use ODBC. Excel ODBC
driver is preinstalled with Windows.

The example of conection string:

'Driver={Microsoft Excel Driver (*.xls)}; FIRSTROWHASNAMES=0;
READONLY=FALSE; DBQ=C:\test.xls'

Roman

[Back to original message]