Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem importing text into excel 2007
Hello,
I have data files (1 per day) that are downloaded from a vendor site. The files come accross with a WR1 extention. I beleive this is a Lotus Syphony format. The data length of each row is about 480 characters in the WR1 file. When i import the data into excel 2007...it is truncating the data at 255 characters. I thought that cap on cell length was eliminated in 2007. So I tried opening the file using MS Word. the full row was shown. I copied and pasted the data from Word into excel and the full row with 480 characters shows up in the first cell. That is the result i am looking for, but would love to have it happen in just one step. I do not want to have to open in word and transfer to excel. Once the data is in the single cell in Excel, i can easily parse the data according to the record layout. So any idea why i cant import the text or open the text file in Excel 2007 without truncating the data? Many thanks for your suggestions. PivotMan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem with open text file in excel 2007 | Excel Discussion (Misc queries) | |||
Importing Text files to Excel 2007 | Excel Discussion (Misc queries) | |||
problem in importing text file! | Excel Discussion (Misc queries) | |||
importing a text file - problem with dates "Americanising" | Excel Discussion (Misc queries) | |||
Problem importing to Excel | Excel Discussion (Misc queries) |