NYCPHP Meetup

NYPHP.org

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

nyphp at jimbishop.org nyphp at jimbishop.org
Wed Jul 24 13:46:56 EDT 2002


> 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

export the excel file as a tab-delimited file and use the import file
feature of mysql.

http://www.mysql.com/doc/L/O/LOAD_DATA.html




More information about the talk mailing list