Application to unpack file?

W

WMB

Is there an application I can use to unpacked packed text files? The packed
file is a result of an as400 export which can not be changed. My desired end
result is to be able to import the text file into Microsoft Access 2007.
 
A

Arvin Meyer [MVP]

You'll need to do this in the file system then convert the resulting text
file from Unix to Dos by adding a line feed character. I use code like this
when importing:

Public Function UNIX2DOS(ByVal str As String) As String
UNIX2DOS = Replace(str, Chr(10), Chr(13) & Chr(10))
End Function

It must run for each line in the AS400 file. If the File is binary, instead
of ASCII text, you'll need to convert it to text on the AS400 before
importing it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top