[Eug-lug] Importing a .csv file into MySql

[Ben Barrett]

If you can use phpMyAdmin you might have some easier luck yourself.  If you
need pre-processing of the CSV you'll need something like scripting, but
spreadsheet operations might be able to get you going with less coding....
the mysql command sequence "load data LOCAL infile" should help you out a
lot :)
try this google search:
http://www.google.com/search?q=3Dmysql%20csv%20import
feeling lucky has some help for you http://www.modwest.com/help/kb6-253.html
see their php scripts, and the load data local infile sequence...

ciao,

ben


On 8/22/07, Ron LeVine <levine.ron at gmail.com> wrote:
>
> Greetings all,
>
> I have a .csv file from a spreadsheet that I want to import into a MySQL
> db. Unfortunately, the format of the file is not the same as the field li=
st
> in MySQL so I think I need a script to parse the file and then do the MyS=
QL
> commands to place the data where it goes.
>
> I am not much of a script guy. Anyone care to assist on this???
>
> Thanks in advance,
> Ron
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://euglug.org/pipermail/euglug/attachments/20070822/36022539/attac=
hment.htm