my problem is that: i have a large excel file, about 1.6 megs.i have to use the info in it on the web, using php/mysql.my question is:what is the best solution, time-regarding to be able to browse it?
i have come up with the following:
1.create a dsn connection to the file, using odbc and then use odbc functions included in php.
2. create a dsn-less connection using COM objects
3.import the excel file into mysql using csv files.
the server on which i must upload this on is a linux server, i don't know if the first 2 solutions work on linux.but, which one is the best? i'm sorry if i have said anything stupid
i have come up with the following:
1.create a dsn connection to the file, using odbc and then use odbc functions included in php.
2. create a dsn-less connection using COM objects
3.import the excel file into mysql using csv files.
the server on which i must upload this on is a linux server, i don't know if the first 2 solutions work on linux.but, which one is the best? i'm sorry if i have said anything stupid