Hi there, I have an xls file to manage my hockey pool. I would like to get it on the web with php but I don't need an SQL db for that matter. Do yo guys have any other solution for this?
Thanks.
K.
use the odbc driver for excel.
Export the file as a tab delimited ascii file and parse each line of the contents manually using explode( "\t", $line). See also, fopen(), fgets() and fclose().
In this case, I would have to convert my multiple sheet Excel workbook but that is fine.
Then you should consider using a db approach instead of a flat file.