Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004

    Unanswered: Excel to mySQL with PHP

    I am dsperately trying to find a method to transfer an Excel spreadsheet to a mySQL database without first saving as a .csv file. I have found all the Windows GUIs and the ODBC but nothing for a Unix sys.

    Please help.

  2. #2
    Join Date
    Jul 2004
    Dundee, Scotland
    A solution to the problem you describe does not exist.

  3. #3
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    1) Since excel does not run on Unix, an easy solution may not exist.
    2) This can be done via PERL, regardless os underlying OS.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Jul 2004
    Convert the Excel file to Access. There are many ways to accomplish this. Copy/Paste is the easiest, or you can exoprt to CSV and import from CSV. Go to and download and install MySQL-FRONT on your Windows box. The free version will allow an ODBC import from Access to MySQL. It will cretae the exact table structure you have in Access! You will have to configure the MySQL server to talk to your Windows box.

    Mark Casazza

  5. #5
    Join Date
    Mar 2004
    On Linux, the only way I can forsee is to convert them into .CSV and use LOAD LOCAL command.

    One windows, you can use MySQL Front as reported or even SQLyog ( )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts