G
Guest
I have a large ASCII file I want to import into excel.
The problem is that this file has over 1,800 columns of data and Excel only
has 256. So after I import the file I get a nice message that says, "Not All
Data Imported" or something to that effect. Great.
I noticed that there is a nifty Option group on the third step of the Text
Import Wizard that allows you to skip columns. This is semi-good because now
I can import all the data 256 columns at a time... but that sucks because
there are 1,800 columns in the file. And it would be tedious if not
impossible to actually try and count 256 columns in that little preview
screen Excel provides.
I thought I would write a quick function to do this by modifying the
FieldInfo Argument of the OpenText Method to reflect a new group of 256
columns. However, this requires me to create an array that has 256
dimensions... which alas is not allowed.
Any thoughts? I really don't want to have to import 256 columns at a
time... This wouldn't be too bad if it were one file... but there are
hundreds...
John
The problem is that this file has over 1,800 columns of data and Excel only
has 256. So after I import the file I get a nice message that says, "Not All
Data Imported" or something to that effect. Great.
I noticed that there is a nifty Option group on the third step of the Text
Import Wizard that allows you to skip columns. This is semi-good because now
I can import all the data 256 columns at a time... but that sucks because
there are 1,800 columns in the file. And it would be tedious if not
impossible to actually try and count 256 columns in that little preview
screen Excel provides.
I thought I would write a quick function to do this by modifying the
FieldInfo Argument of the OpenText Method to reflect a new group of 256
columns. However, this requires me to create an array that has 256
dimensions... which alas is not allowed.
Any thoughts? I really don't want to have to import 256 columns at a
time... This wouldn't be too bad if it were one file... but there are
hundreds...
John