[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: Excel to Sql




> Is there a way to import a table from an excel spread sheet to a MySql
table??
>
> Kirk
>

In Excel, select export to csv (comma separated value) file.  Transport this
to your Linux machine, and take care of any Dos2Unix problems (like ^Ms,
etc.).  Then go read this link:

http://mysql.com/Manual_chapter/manual_Tools.html#mysqlimport

And get used to reading the MySQL manuals online.  They are thorough and
quite good....


Eric Cifreo
Austin, TX



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]