| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Last Column(=spaces) is Dropped When Importing from .Txt file
I am importing a text file from the mainframe in which the last
field of the record is spaces. After transfer of the file down to my PC as a text file, I then wish to import it into Excel. Excel is truncating the last column and wiping out my record length which needs to be a fixed record length. After user corrections, the Excel file will then be formatted back to text and processed by another PC application. Any suggestions on how to prevent the truncation of the last column of my records? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
| Importing Text Files | Excel Discussion (Misc queries) | |||
| How do I ignore newline character/carriage return while importing | Excel Discussion (Misc queries) | |||
| Importing text files with mathematical characters | Excel Discussion (Misc queries) | |||
| importing excel spreadsheets into web-based applications | Excel Discussion (Misc queries) | |||
Threaded Mode
