Import multiple CSV files into a single MYSQL table

Discussion in 'MySQL' started by mcf1992, Jun 7, 2012.

0
  1. #1
    How would I go about importing several CSV files into a single table? Any advice is greatly appreciated!
     
    mcf1992, Jun 7, 2012 IP
  2. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #2
    Append each one, one at a time. (Use INSERT or phpMyAdmin.)
     
    Rukbat, Jun 16, 2012 IP
  3. barnsley

    barnsley Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Have you managed to resolve this issue yet of importing several csv files into a database table?There is an example here (although its not mySQL, so not sure what its capabilities are) - it uses a DTS package (to insert the data) and a batch file to list all the csv files.Article by Muthusamy Anantha Kumar. http://www.databasejournal.com/featu...-Using-DTS.htm
     
    barnsley, Nov 6, 2012 IP