"a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf (AT) gmail (DOT) com> wrote

You are a naughty boy, Aaron. If you talk like that to people in person,
sooner or later, even in a generally peaceful place like Washington, you're
likely to run into someone that'll make you wish you had just stayed in the
slammer and learned to appreciate the protection it offered you.

MDB and Jet or ACCDB and ACE, ODBC, SQL Server _or any other ODBC-compliant
server_ works very nicely (and has longer than the "extensive" database
career you claim); and, although you don't keep sufficiently up-to-date to
know it, it is what is recommended by the Access team at Microsoft as the
preferred solution. ADP, on the other hand, is "to all intents and
purposes, deprecated" and has not been enhanced in the last several versions
of Access

If your posting history is any indication, you are lying, because you have a
history of recommending people use ADP when it is clearly not the "best"
solution, except in your warped and biased view.

Clif or anyone else,

If you want to see a sample approach that uses Pentaho Data
Integration (PDI) for loading files to a table and validating them as
part of the process I am happy to skooch a few examples I have created
to you. One other thing you can do with PDI that I havent mentioned,
and is especially useful if you have giant data sets to work with, is
the use of PDI slaves. You can run PDI as a slave (background process)
in either windows or linux and have an independant machine (or army of
machines) doing the integration process heavy lifting, including
pushing the data to and fro from db servers. You can also execute the
ETL process(es) you want from command line if it works for you best.

Cheers

The Frog

"The Frog" <mr.frog.to.you (AT) googlemail (DOT) com> wrote


Very generous offer! and is a sample of why I consider these ng's my
primary source of information and instruction! <g>

For my situation, this is pre-mature, but I'll definately keep it in
mind.

Thanks!

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)