i have a mdb db, i use with asp
i want to switch to php
i want to use perl to convert the csv produced from this mdb to make a many many lined
sql statement for my php db, in order to get the
data to it
so in perl, how do i turn each line of csv data into sql statements by adding "insert
into"... etc etc...
i want to take 44, jon, doe, 3479, alabama
and add "insert into TABLENAME id, first, last, number, state VALUES ("
$the_csv_string_one_per_row ")";
so in my linux websever's cgi-bin directory, what will the pl script look like:
ex:
#!/user/bin/perl
open (infile, "text.csv");
@indata = infile;
foreach???
something like this?
thanks a ton, i've gotten a lot of error's trying to do this for days...?
bc
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
