[AccessD] Import File From UNIX box

MartyConnelly martyconnelly at shaw.ca
Thu Aug 12 14:40:48 CDT 2004


 From the dim distant past of DOS 2.1 and QNX, I remember doing 
something like this to tag data onto the end of .exe and .com files.
The character is known as CTL-Z octal 32, however I believe UNIX may use 
CTL-M. Neither is mandated.
DOS used Ctrl-Z because CP/M did. CP/M used a Ctrl-Z to mark the end of 
a text file because the CP/M filesystem only kept track of how many
512-byte blocks were in a file, not exactly where the last byte of data 
was in that last block. So, many applications wrote a Ctrl-Z at
the end of a text file to mark the end. This behavior was a a carry-over 
from DEC software probably RSX-11.

You might want to use UltraEdit it recognizes various odd Unix file 
formats and converts to DOS text. http://www.ultraedit.com
You can read the file as binary and do the the byte conversions for lf 
to crlf and eof characters as necessary.


Mark A Matte wrote:

> Hello All,
>
> I thought this situation had passed.
>
> First, Thanks for all the feedback...for the most part...the 
> conversion went fine.
>
> The problem is the file I am converting contains a field that is 'free 
> text' and is often copied/pasted from other applications. In the 3rd 
> record...in this field, there is a character that is interpreted as 
> EOF...so my code stops without an error...but only the first 2 records 
> are imported. Is there any way to test for this situation(2 EOFs or 
> when there is data past EOF)?
>
> Thanks,
>
> Mark A. Matte
>
>
>
>
>> From: "Pedro Janssen" <pedro at plex.nl>
>> Reply-To: Access Developers discussion and problem 
>> solving<accessd at databaseadvisors.com>
>> To: "Access Developers discussion and problem 
>> solving"<accessd at databaseadvisors.com>
>> Subject: Re: [AccessD] Import File From UNIX box
>> Date: Fri, 30 Jul 2004 23:10:22 +0200
>>
>> Hello Mark,
>>
>> i use VBA on Reflection FTP to send a unix file as an ascii file
>> to an windows box. Then it is imported with no problems in access.
>> If you want the code, let me know, i will send you this next week
>> from my work.
>>
>> Pedro Janssen
>>
>>
>>
>> > >From: "Mark A Matte" <markamatte at hotmail.com>
>> > >Reply-To: Access Developers discussion and problem
>> > >solving<accessd at databaseadvisors.com>
>> > >To: accessd at databaseadvisors.com
>> > >Subject: [AccessD] Import File From UNIX box
>> > >Date: Thu, 29 Jul 2004 13:48:01 +0000
>> > >
>> > >Hello All,
>> > >
>> > >I have an A97 db that imports a text file. The text file was on a
>> Windows
>> > >box...but now is generated and sent to a UNIX box. The UNIX 
>> version of
>> > >this text file has a CR or LF character after each record...and 
>> access
>> sees
>> > >this as the end of the file. Any suggestions in using vba to convert
>> this
>> > >file(or those characters) back to a Windows format/
>> > >
>> > >Thanks,
>> > >
>> > >Mark A. Matte
>> > >
>> > >_________________________________________________________________
>> > >Overwhelmed by debt? Find out how to 'Dig Yourself Out of Debt' 
>> from MSN
>> > >Money. http://special.msn.com/money/0407debt.armx
>> > >
>> > >--
>> > >_______________________________________________
>> > >AccessD mailing list
>> > >AccessD at databaseadvisors.com
>> > >http://databaseadvisors.com/mailman/listinfo/accessd
>> > >Website: http://www.databaseadvisors.com
>> >
>> >
>> > --
>> > _______________________________________________
>> > AccessD mailing list
>> > AccessD at databaseadvisors.com
>> > http://databaseadvisors.com/mailman/listinfo/accessd
>> > Website: http://www.databaseadvisors.com
>> >
>> >
>>
>>
>> -- 
>> _______________________________________________
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
>
> _________________________________________________________________
> Don’t just search. Find. Check out the new MSN Search! 
> http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list