[AccessD] Import File From UNIX box

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/