Thread: What's the best way to sync an Excel spreadsheet and a MySQL database

  1. #1
    User
    Join Date
    Jan 2006
    Location
    Canada
    Posts
    499

    What's the best way to sync an Excel spreadsheet and a MySQL database

    I've got a webpage powered by php/MySQL, and I need to import an Excel spreadsheet into the MySQL database. It's not really that complicated; just one table.

    The problem is that all the tools I've found are either commerical (I like things free ), or they only run on Windows, or both.

    What I need is a solution that allows me to import my spreadsheet, and keep it synced, because it is likely that I will be adding more records to my spreadsheet.

    And I certainley can't hand-type it, because I've got around 500+ records that I need to import. I tried using this, but it didn't quite work: some of the data was in the wrong fields, and trying to correct all those records would be almost as hard as hand typing.

    So please, if anyone has an idea, say so. They will be appreciated greatly.

  2. #2
    and the hat of int overfl Salem's Avatar
    Join Date
    Aug 2001
    Location
    The edge of the known universe
    Posts
    39,660
    1. Save the excel file as a .csv, which is very easy to parse.

    2. Rummage in the source code of openoffice, which can read excel files.
    If you dance barefoot on the broken glass of undefined behaviour, you've got to expect the occasional cut.
    If at first you don't succeed, try writing your phone number on the exam paper.

Popular pages Recent additions subscribe to a feed