This is partial code, which does not work. I am not sure how to added the text line to access table. Any help? 
my $line;
while ($line = <lbc*.txt>){
    open (LOGFILE, "$line")  || die "Can't open LOGFILE \n";
    while(<LOGFILE>) {
        my($tdater, $filen, $ttot, $ttot2, $logfilen, $tots, $diff) = 
        split(/\|/);
        chomp ($tdater);
        chomp ($filen);
        chomp ($ttot);
        chomp ($ttot2);
        chomp ($logfilen);
        chomp ($tots);
        chomp ($diff);
        print ("$tdater", "$filen", "\n"); 
        my $theyear = 2000 + substr $tdater,6,2;
        my $themo = substr $tdater, 0, 2;
        my $thedt = substr $tdater, 3, 2;
        my $thedate = $theyear . "/" . $themo . "/" . $thedt;
        my $quer1="INSERT into logfile 
    ('Date Send', 'Certificate file', 'No of Certificate', PDFNO, 'log
+ file', 'Notice sent', Difference)
        VALUES ({d '$thedate'}, '$filen', '$ttot', '$ttot2', '$logfile
+n', '$tots', '$diff')";
          my $query = q! 
          INSERT INTO logfile ("Date Send", "Certificate file")
          VALUES ({d '$thedate'}, $filen)
            !;
            
         if ( $db->Sql($query))
             {
                print "error executing query [ \"$query\" ]\n";
                print "Error: " . Win32::ODBC::Error() . "\n";

        }
    }
    close(LOGFILE);
}

[download]

In reply to Add Text record to access table? by manoorani

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.