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=mysql%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 <[EMAIL PROTECTED]> 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 list > in MySQL so I think I need a script to parse the file and then do the MySQL > 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 > >
_______________________________________________ EUGLUG mailing list [email protected] http://www.euglug.org/mailman/listinfo/euglug
