August 10th, 2000, 12:31 PM
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,
August 10th, 2000, 06:48 PM
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 ).