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!

xl2007 has 16384 columns. And it should be released real soon now.



(E-Mail Removed) wrote:
>
> 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!

--

Dave Peterson

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

CLR wrote:
> I would try Recording a Macro while doing the entire job once more by
> hand.....perhaps it will not work perfectly, but may give you a good base to
> edit.
>
> hth
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
>
> "(E-Mail Removed)" wrote:
>
> > 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!
> >
> >