Re: format 'prn' to ACCESS

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

And I just discovered that MS Access does NOT strip leading zeroes when a 
number is quoted. I.e., it interprets quotes as text fields, no matter 
what, when you open a CSV. It does bring up a wizard, where you could 
change the data type if you wanted.

This is different from MS Excel - refer to a recent discussion on that topic.

BTW, if you have any decimal places (other than 0) or negative numbers, the 
FTP will not work - the decimal point is not sent, and the sign modifies 
the last character, so it is not a digit. Of course, you might be lucky and 
not have these problems. ;-)

Vern

At 12:27 PM 2/26/2004 -0500, you wrote:
> You can't put directly into Access format (it uses the mortally lame JET
> database), but you can do a CPYTOIMPF and put it on the IFS in comma
> delimited format. You could then FTP that file and import it into Access.
>
> On Thu, 26 Feb 2004 09:14:29 -0800 (PST), "murali dhar"
> <hydchap1@xxxxxxxxx> said:
> > Dear all,
> >
> > Iam sending a file to downstreams by FTP with
> > following cmd.
> > PUT qs36f/ysmam001.ysmam001 am001.$DATE$.prn
> > (as per earlier request by Downstreams 'prn' format
> > was mentioned since it accomodates certain
> > requirments.)
> >
> > Now they want the information into ACCESS.
> >
> > is it be possible to send  the file in an Access
> > Database format instead? and how?
> >
> > Thank you for your help in adv,
> > Thank you for your patience,
> > Murali.