Advanced export/ Fixed length fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

raws - 11 Jan 2006 15:53 GMT

In excel 97, when you did an export of a worksheet to a .txt file yo
were able to do an advanced options export. Now I cannot find an
reference to this ability in 2002.
Basically I have data that needs to be uploaded to a mainframe, and th
only way that the mainframe will take it is with a .txt file that ha
fixed length. This can still be done in paradox, but then I have t
find a copy of it. It just seems like this is a feature that shoul
not have gone away from Excel, but then again maybe I am losing m
mind.

Thanks,
Ross K

:confused

Reply to this Message

wjohnson - 12 Jan 2006 07:34 GMT

Go to FILE - SAVE AS - and then in the SAVE AS TYPE - Scroll down until
you find "Formatted Text (Space Delimited *.prn), this should work for
you. If you cannot find it then you might need to reinstall "ALL" of
the EXCEL conversion that are available. If you do the normal install
of OFFICE - sometimes you do not get ALL of the conversion features
added to the your programs. Then you can rename the *.prn to *.txt and
import into your other program. Just be sure to use a COURIER font to
view it, otherwise - text may not look like it lines up.

Signature

wjohnson

Reply to this Message

raws - 12 Jan 2006 14:38 GMT

Thanks for your help!

Signature

raws

Reply to this Message