NYCPHP Meetup

NYPHP.org

[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