RE: [PCTECH] automagically import a .CSV into Access db table from CL?

["Dan Bale" <dbale@xxxxxxxxxxxxx>]

VB or any other PC programming idea is out.  KISS is the rule of the day.

Security not a problem, since only three of us in the I.S. department have
the necessary write authorities on the folder that holds the Access
database.

db

> -----Original Message-----
> From: pctech-bounces@xxxxxxxxxxxx / Michael Naughton
> Sent: Tuesday, October 19, 2004 5:48 PM
>
> The suggestions of using an ODBC link or using a CL program to run a PC
> command are both good ones -- depending on your circumstances, either one
> should work fine.
>
> Another option, if you've got Visual Basic available, is to write a VB
> program that gets the data off the AS/400 and then pumps it into Access.
> This would give you a lot of control over how you do it, and you could
> fire up the whole process with one click. . . .