If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Advanced export/ Fixed length fields
In excel 97, when you did an export of a worksheet to a .txt file you were able to do an advanced options export. Now I cannot find any reference to this ability in 2002. Basically I have data that needs to be uploaded to a mainframe, and the only way that the mainframe will take it is with a .txt file that has fixed length. This can still be done in paradox, but then I have to find a copy of it. It just seems like this is a feature that should not have gone away from Excel, but then again maybe I am losing my mind. Thanks, Ross K -- raws ------------------------------------------------------------------------ raws's Profile: http://www.excelforum.com/member.php...o&userid=30366 View this thread: http://www.excelforum.com/showthread...hreadid=500197 |
#2
|
|||
|
|||
Advanced export/ Fixed length fields
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. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=500197 |
#3
|
|||
|
|||
Advanced export/ Fixed length fields
Thanks for your help! -- raws ------------------------------------------------------------------------ raws's Profile: http://www.excelforum.com/member.php...o&userid=30366 View this thread: http://www.excelforum.com/showthread...hreadid=500197 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
save an excel file in fixed length records whose fields are blank | ascii save | General Discussion | 1 | October 13th, 2005 06:01 PM |
Exporting to Fixed Length Text file | kwright | General Discussion | 2 | September 19th, 2005 03:05 PM |
How can I export Misc fields such as reminder date from contacts . | Sue Mosher [MVP-Outlook] | Contacts | 1 | August 29th, 2005 10:59 PM |
Select Table Fields for Export | [email protected] | General Discussion | 2 | June 17th, 2004 12:59 PM |
Can't export calculated fields to Excel | Sharon Caspers | Setting Up & Running Reports | 0 | May 26th, 2004 08:31 PM |