MySQL people: putting excel values in database

Discussion in 'OT Technology' started by NEOxMorpheus, Nov 20, 2005.

  1. NEOxMorpheus

    NEOxMorpheus Real OG

    Joined:
    Oct 24, 2001
    Messages:
    1,001
    Likes Received:
    0
    I was wondering how you would insert data from a excel spreadsheet into a database.

    I know you can use
    LOAD DATA INFILE "stuff.dat" INTO TABLE table FIELDS TERMINATED BY ','

    for regular text files, but not sure what the fields in excel will be terminated by
     
  2. Peyomp

    Peyomp New Member

    Joined:
    Jan 11, 2002
    Messages:
    14,017
    Likes Received:
    0
    Unless there is a tool to do this for you, I think you would have to use an ODBC driver on the Excel file, and then query the excel table and insert the results in the MySQL table.
     
  3. Peyomp

    Peyomp New Member

    Joined:
    Jan 11, 2002
    Messages:
    14,017
    Likes Received:
    0
  4. NEOxMorpheus

    NEOxMorpheus Real OG

    Joined:
    Oct 24, 2001
    Messages:
    1,001
    Likes Received:
    0
    nice. thanks for the help
     

Share This Page