List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:December 8 2004 4:02am
Subject:Re: Excel 2 mysql
View as plain text  
The easiest way to turn excel into MySQL is to have excel save the
file as a .csv (comma separated values) file and use the mysqlimport
utility or a load data infile query to insert it into a table in
MySQL.

-Eric


On Tue, 7 Dec 2004 16:02:23 -0800, David Ziggy Lubowa
<dlubowa@stripped> wrote:
> 
> Hey guys ,
> 
> i know this has been discussed but looking through the archives i have more
> less hit a stand still , i have one big excel file which has data i would
> like to extract., Now i am no expert in perl neither am i in php , i have
> looked at some tools like navicat but i dont see where you actually start the
> app , if that is what happens.  Any help is highly appreciated.
> 
> cheers
> 
> -Z
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 


-- 
Eric Bergen
eric.bergen@stripped
http://www.bleated.com
Thread
Excel 2 mysqlDavid Ziggy Lubowa7 Dec
  • Re: Excel 2 mysqlEric Bergen8 Dec
    • Re: Excel 2 mysqlDavid Ziggy Lubowa8 Dec
      • RE: Excel 2 mysqlAndy Eastham8 Dec
      • Re: Excel 2 mysqlIan Sales8 Dec
  • Re: Excel 2 mysqlMukasa Assey Alfred8 Dec
  • Re: Excel 2 mysqlAdam8 Dec
  • Re: Excel 2 mysqlPatrick Sherrill8 Dec
    • Re: Excel 2 mysqlDavid Ziggy Lubowa9 Dec
      • Re: Excel 2 mysqlDavid Ziggy Lubowa9 Dec
        • Re: Excel 2 mysqlDavid Ziggy Lubowa9 Dec
        • Re: Excel 2 mysqlIan Sales9 Dec
  • Re: Excel 2 mysqlPatrick Sherrill9 Dec
RE: Excel 2 mysqlJay Blanchard7 Dec
  • Re: Excel 2 mysqlIan Sales7 Dec