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

That would be great.  Could it be invoked from the CL program?  

If not from CL, could it be done on the PC from a single click of an icon?

db

> -----Original Message-----
> From: pctech-bounces@xxxxxxxxxxxx / Adam Lang
> Sent: Tuesday, October 19, 2004 4:46 PM
> 
> Why not just import the as/400 db file straight into Access with ODBC?
> 
> ----- Original Message ----- 
> From: "Dan Bale" <dbale@xxxxxxxxxxxxx>
> To: <pctech@xxxxxxxxxxxx>
> Sent: Tuesday, October 19, 2004 4:10 PM
> Subject: [PCTECH] automagically import a .CSV into Access db 
> table from CL?
> 
> 
> > Creating a .CSV file from an AS/400 file and importing that 
> into an Access
> > db table.  Trying to cut down on the number of manual steps 
> needed to get
> > from point A to point Z.
> >
> > Is there an easy and reliable way for a CL program to invoke the steps
> that
> > import the CSV into a specific Access table?  It would have to 
> replace the
> > existing data in the table.
> >
> > tia,
> > db