I'm sorry for the confusion...no they are in cvs files now. They get loaded into an access db for processing. In my first of my 3 less-than-stellar posts I had a typo that said 'is working fine', but really it should have been 'isN'T' working fine.
The import functions ok unless you try to import the 1st or last file, & when the year rolls over, there is a 2 day waiting period.
I could probably fix it in VBA, but it seemed like a great chance to exercise & expand my perl. Maybe I'm wrong. I guess time will tell.
Also, every now & then the thing crashes & I have to manually delete several tables just to get it to run again. It's a single user app & he's very patient. It's been thru 3 Windows/Office upgrades. I'd just hoped to enhance it for him in a more stable environment.
I'm doing this for free outside of work, just because it saves him about 14 hours that he puts into Excel on his weekend & I need the learning. Thanks again for the help. The monestary has been immeasurably helpful.

In reply to Re^2: Looking for some design guidance by Aim9b
in thread Looking for some design guidance by Aim9b

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.