[nycphp-talk] Does anyone know how to migrate the data from MS Excel to MySqL?
Adam
adam at ecamp.net
Wed Jul 24 13:43:15 EDT 2002
export them as tab delimeted csv files
then from the mysql command line
load data infile '/tmp/filename.csv' into table blah (field1,field2....)
On Wed, 24 Jul 2002, ken wu wrote:
|Hi, all. I now have a bulk of data in Excel files
|needed to migrate to MySql Database. Honestly, I
|would like to know if there is any software or script
|that can do that in any sense? Any suggestion would be
|greatly appreciated. thx
|
|
|
|
|
|
|
|=====
|Ken Wu
|
|718-788-0661
|168 35 Street Apt 2
|Broooklyn, NY 11232-2320
|
|http://www.kenfile.com
|
|__________________________________________________
|Do You Yahoo!?
|Yahoo! Health - Feel better, live better
|http://health.yahoo.com
|
|
More information about the talk
mailing list