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

This is a discussion on What's the best way to sync an Excel spreadsheet and a MySQL database within the Tech Board forums, part of the Community Boards category; I've got a webpage powered by php/MySQL, and I need to import an Excel spreadsheet into the MySQL database. It's ...

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

    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 wrongness Salem's Avatar
    Join Date
    Aug 2001
    Location
    The edge of the known universe
    Posts
    32,434
    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.
    I support http://www.ukip.org/ as the first necessary step to a free Europe.

Popular pages Recent additions subscribe to a feed

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21