Thread: mysqlimport

    #1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Norcross, GA
    Posts
    458
    Rep Power
    15
    I have a *.xls file that i'd like to import to a blank table. I've saved the file in csv format as well.

    The top row contains the field names, each subsequent row is a record. The feild names do not have 'quotes' - I'm not sure if I'd need to manually put them there, or if an import tool will do it for me.

    mysqlimport looks interesting, but i'm not too clear on how to use it in this specific case. In the examples i've looked at, there is no way to specify which table you want to import the data to.

    TIA for your help,
    Mike
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    The trick with mysqlimport is that the filename of your text import file (minus the extension) is the table name you are importing into. If you want to import into table 'users', you could direct mysqlimport to the files 'users.csv' as your import file.

    Mysqlimport can be tricky. If you have PHP installed on your server, then the web-based admin kit phpMyAdmin is an excellent aide for these things. ( http://www.phpwizard.net ).

Similar Threads

  1. mysqlimport
    By pocon in forum MySQL Help
    Replies: 0
    Last Post: March 10th, 2003, 11:17 AM
  2. Enable mysqlimport
    By pocon in forum MySQL Help
    Replies: 0
    Last Post: March 5th, 2003, 04:08 PM
  3. mysqlimport
    By da_gimp in forum MySQL Help
    Replies: 4
    Last Post: August 14th, 2001, 02:45 AM
  4. mysqlimport mysteriously fails
    By jimp123 in forum MySQL Help
    Replies: 2
    Last Post: February 23rd, 2001, 01:17 PM
  5. mysqlimport
    By cryogen in forum MySQL Help
    Replies: 3
    Last Post: August 9th, 2000, 01:38 PM

IMN logo majestic logo threadwatch logo seochat tools logo