loading txt files with more than 256 columns

[Pilgrim]

Hi,

I have an txt-file with 288 rows and 384 columns. I want to display these
value in an 3-d surface chart. It is not possible to load the complete file
due to the limitation of 256 columns of excel. Is it possible to load the
txt-file in two paeces with "OpenText" or is there another possible function
to achieve this?

Thanks

 

[Tom Ogilvy]

Even if you could load it, you couldn't display the data in a 3D surface
chart. A surface chart requires x values down one column, y values across a
row and Z values at the intersection. Doesn't sound like your data and it
it is arranged that way, you couldn't set it up on a single sheet.

You can open it with opentext by specify which columns to skip so that it
pulls in 256 columns or less on one pass and the remainder on another.

 

[Pilgrim]

Thank you for your help,

but how can I specify which column to skip with the opentext method and how
can I get access to remaining columns? Always when I load the first columns I
get no access to the remaining columns.

Thanks,

Simon

 

[Tom Ogilvy]

Turn on the macro recorder and open a text file that only has a few columns.

in the final part of the text import wizard, identify a column or two to
skip.

then turn off the recorder and look at the code. The information is in the
array at the end of the OpenText command. The help file on opentext should
show you what they mean.

 

[Pilgrim]

Thank you for your help!

Simon

Turn on the macro recorder and open a text file that only has a few columns.

in the final part of the text import wizard, identify a column or two to
skip.

then turn off the recorder and look at the code. The information is in the
array at the end of the OpenText command. The help file on opentext should
show you what they mean.