Bruce Young wrote:
> >Bruce, you did not say "how" you are getting the files from the outside
> >source, but let's assume that they are text files. If so, you should
> >consider using Perl on your NT with the DBI module to process
> the text file
> >into the Access tables. It is much more efficient than having CF
> do it. CF
> >just ain't built as a text processor.
>
> Thanks Jack
> I did mention the text file... they get sent to me each night. :) Yes, the
> use of Perl to do the initial DB procesing has been suggested as that is
> what Perl is good at. I've just not used a DBI module before in Perl...
> which I'm revisiting after a 2 year absence to do some custom Lyris
> interfacing at the moment.
I think you'll find the DBI module fairly straightforward. You'll need to
know a little SQL to insert or update your database, too. A plus regarding
the DBI module is that if you *do* decide to start using another database,
you will have to change very little in your Perl script, since DBI will
interface with a wide variety of DB's.
> I might also see if I can get those who do the inital export of
> the data to
> improve the quality of what they send so I can reduce the amount of
> cleaning up I have to do.
Good luck. The more they can automate, the less work you have to do, eh?
Jack
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
