How can I import a csv file with over 256 columns into Excel?
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!
|