View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] aaron.overington@consumerlink.co.nz is offline
external usenet poster
 
Posts: 2
Default 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!