MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2004

Re: automate .CSV create from CL



fixed

On Tue, 2004-10-19 at 21:09, Dan Bale wrote:
> 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.
[snip]
> 
> Also, I tried CPYTOIMPF, and this works seemingly well, but this method does
> not trim trailing blanks from text fields, whereas the "Data Transfer From
> iSeries" method does.  I'm not sure if there are any implications of those
> differences when the data is imported into Access.  Anybody know?

Hi Dan

You could try the CRTCSVSTMF utility from my site. That creates .csv
files similar to CPYTOIMPF, but trims trailing blanks, plus allows some
extra formatting of fields within the file (changing date formats, etc).
Details and source code download from  http://www.dbg400.net/crtcsv.html

Regards, Martin
-- 
martin@xxxxxxxxxx  AIM/Gaim: DBG400dotNet  http://www.dbg400.net       /"\
DBG/400 - DataBase Generation utilities - AS/400 / iSeries Open        \ /
Source free test environment tools and others (file/spool/misc)         X 
[this space for hire]  ASCII Ribbon Campaign against HTML mail & news  / \






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact