large excel file importing

[sundogro]

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

[brandonschnell]

depends.

with a small 1.6 meg file i'd use odbc if you need to transfer the file on a regular basis.

otherwise, export from excel to a cvs file, and use mysqlimport. it'll be a lot faster to setup. just copy the file over and check the program options. import into a test table/database to be sure the transfer is successful before importing into the real table.

[ame12]

See the BadBlue server's transcoding features... it will allow browsing of an Excel spreadsheet or Access database through the web with basically no work involved.

http://badblue.com/helpxls.htm

There is a free download to try it.