Re: format 'prn' to ACCESS -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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.

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.