How do I do this with MS Excel (CSV and MySQL)

Discussion in 'MySQL' started by peppy, Jun 10, 2010.

0
  1. #1
    I would like to make a label above each of the columns, which describes what data is in each column, but I do not want these words in the spreadsheet itself because I need to import the CSV into the MySQL database.

    How can I do this?

    Thanks
     
    peppy, Jun 10, 2010 IP
  2. cDc

    cDc Peon

    Messages:
    127
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    If you are using the LOAD DATA command in MySQL there is an option to ignore the first row of the CSV file.
     
    cDc, Jun 11, 2010 IP
    peppy likes this.
  3. peppy

    peppy Active Member

    Messages:
    389
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    95
    #3
    excellent!

    Thanks
     
    peppy, Jun 11, 2010 IP