Well, guys, you both are talking way over my head on this. Oh well.
Thanks anyways, Ron On 8/22/07, larry price <[EMAIL PROTECTED]> wrote: > > 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. > > > > This is a very straightforward data filter script, the general pattern > goes like this > > using your favourite scripting language > > read each line of the file into a hash table (dictionary) > > write the output function that does whatever formatting, interpolation > and calculation you need to produce the database table row you need > from the hash structure you have. > > apply the output function to each line, and either stuff the result > into the database directly, or into a file for importation later. > > (for larger data sets the copy function your DBMS has is significantly > faster than inserting row by row) > > > > > > > > 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 > > > > > _______________________________________________ > EUGLUG mailing list > [email protected] > http://www.euglug.org/mailman/listinfo/euglug >
_______________________________________________ EUGLUG mailing list [email protected] http://www.euglug.org/mailman/listinfo/euglug
