Importing text file

  • Thread starter Thread starter SimonT
  • Start date Start date
S

SimonT

I am trying to import a text file which has 260 columns
into Excel 2000. Excel 2000 has a column limit of 256. Is
there anyway I can increase this number?

With Excel 97 although it would not open the extra columns
it did show me the data for the first 256, where as Excel
2000 just comes up with an error and stops.

Any ideas anyone?
 
Can you split the text file in to to 130 column files and
then import it in to to seperate worksheets?
 
Back
Top