how can I import a csv file to Excel that has over 256 columns?

A

aaron.overington

Hi

I have several large csv files (semi colon separated) with over 256
columns of data that I need to convert to xls files. I can manually
import 256 columns into a worksheet, then block those columns and
import the next 256 into a new worksheet, but as some of the csv files
have 750+ columns, is there a programmatical solution though that is
easier (and quicker)? I deal with these files weekly so any help
gratefully accepted!
 
A

aaron.overington

thanks for the advice... I think hanging out for Office 2007 might be
the best bet (about time they expanded the limit!!)
 
Top