Maximum number of column

  • Thread starter Thread starter titan_2004
  • Start date Start date
T

titan_2004

I am working on a program that would import 400 columns of data into
Microsoft Excel. The data is a text file in comma/tab delimited
format. Excel has an allowable range of at most 256 columns. I was
wondering how would I goes about importing this text file into excel.
I'm using visual basic to progam the code. How would I split the file
up so that I would be able to import it into Excel or how would I go
about overcoming this limitation, beside having to utilize a text
editor and row by row shorten the number of columns. The typical text
file is about 2000 rows of data. I appreciate everyone effort in
helping me solve this problem.

Thanks
 
Back
Top