[AccessD] Import File From UNIX box

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
>
>