The answers you are getting are geared toward telling you where
to learn how to do the job. If you want more specific help
you may want to be more specific with your question. Posting
the exact format of the data and how you want it to be
organized under MySQL will empower folks to give you a better
answer.
--
Allen Brown [EMAIL PROTECTED] http://brown.armoredpenguin.com/~abrown/
Always forgive your enemies -- Nothing annoys them so much. ---Oscar Wilde
Ron LeVine wrote:
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]
<mailto:[EMAIL PROTECTED]>> wrote:
On 8/22/07, Ron LeVine < [EMAIL PROTECTED]
<mailto:[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
