[AccessD] Import File From UNIX box

Mark

I had a file that came from a mainframe and I did an exec call to Wordpad,
made an edit and then closed and saved the file in Windows Text format.  The
resultant .txt file was then in Windows format so it could be imported.  I
used VB but I think VBA also allows the same.

Perry Harold

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Thursday, July 29, 2004 9:48 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Import File From UNIX box


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