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

    Neither Excel nor Access are good choices as data stores for shared data. MySQL is a much better option.

    But, you can connect to them via ODBC from a linux box if you have to. I'd only use it as a one way (i.e. read only) conduit to pull data and display it. If you're gonna be editing the data, put it in a dbms like mysql or postgresql on the linux box and save yourself a few headaches.

      ok, but my question was which is the fastest way?as i understand it is to import the file in mysql

        oh yeah, mysql is much faster than hitting an excel or access db remotely, and it's much easier to setup your linux box to talk to a local mysql server than a remote odbc windows box as well.

          Approach 3 works well for me; just export your spreadsheet as tab-delimited text file, convert to UNIX line breaks, put the file into your current directory, and use the MySQL client to import, like this:

          load data local infile "xxx.txt"
          into table xxx
          fields optionally enclosed by '"';

            Write a Reply...