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

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
>
> --
> This is the PC Technical Discussion for iSeries Users (PcTech) mailing
list
> To post a message email: PcTech@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/pctech.