Hello friends

I have an excel sheet with 11,651 records in it. the total size of the file is 19.8 MB. So i cant uplaod it thru a browser. 😕

I cant make the file as CSV (Comma/Semi Colon Delimited) bcos the main excel sheet contains lots of text as description and that text contains " (Double Quotes) or '(Single Quotes) or , (Commas)

So can i write an PHP code which will read the data directly from the excel sheet.

Any help would be grealy appreciated 🙂

    Can't you split the file into smaller one's? (e.g. <= 2M😎
    If so you can import them using phpMyAdmin (so you can specify the field seperators)..

      yeh but phpMyAdmin wont read excel sheets, it requires CSV files. 😕

      i want to read an excel sheet directly without converting to CSV files

      (CSV = Comma/Tab/Semicolon Delimited file)

        you can still use CSV even if your text has quotes etc. CSV can manage that, and phpMyAdmin can also handle it too.

        but, the other option is to use COM.

          So overall this means that i cant do it?? 😢

            17 days later

            i have installed Apache/PHP/MySQL in my office PC.
            and everyday I receive an Excel file in a share directory which I have to import in my MySQL database... and so on.

            So my machine is with Windows 2000,
            and I have made in Delphi program which automates the import of the data from the Excel file to the MySQL.
            It uses DDE to start Excel , open the file, reads all the data and writes it to plain text file. There is no problem to add code instead of writing to text file, the data to be inserted directly to the MySQL.
            But this is possible only on machine with Windows and installed Excel.
            In this case there is no limitation of the size of the file you want to import. You just must have a valid remote account to the MySQL server.
            If you have any questions... feel free to email me at:
            dummy@moito.com

              Write a Reply...