NYCPHP Meetup

NYPHP.org

[nycphp-talk] Does anyone know how to migrate the data from MS Excel to MySqL?

Tony Bollino tbollino at weevinwebs.com
Wed Jul 24 14:28:54 EDT 2002


I had a similar problem.  You will have to clean up the CSV document that
Excel exports.  It's not in a "standard" output.  I had to replace " with '
to get it to work.

Tony Bollino


-----Original Message-----
From: Adam [mailto:adam at ecamp.net]
Sent: Wednesday, July 24, 2002 1:43 PM
To: NYPHP Talk
Subject: Re: [nycphp-talk] Does anyone know how to migrate the data from MS
Excel to MySqL?

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