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!

Wait for Excel 2007?
--
David Biddulph

wrote in message
ups.com...
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!

Well, help is not totally dependent on Excel 2007 showing up on the shelves
<g.

Try this file:
http://www.jlathamsite.com/Uploads/I...umnsOfData.xls
that was put together with your requirements in mind. The only thing I can
think of that may break it is if you have fields that contain the semi-colon
character within them, like
1;5;Hello;6;"with a semi-colon; in it";more;last
All semi-colons are treated as field separators, so that one field would be
split into two columns, as would any others similar to it.

The workbook automatically adds enough sheets to accept the data, and will
overwrite any existing data if you reuse it -- best to either delete old used
sheets or to clear them of existing data before beginning processing.

Thanks to Chip Pearson, there's even a 'sort worksheets' routine included so
that the newly added sheets will be in the proper order to view left-to-right
to see the columns of data in the proper sequence.

Hope this makes life a little easier for you.

" 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!

DUDE!! YOU ROCK!!

thanks so much for this! Works a treat

JLatham (removethis) wrote:
Well, help is not totally dependent on Excel 2007 showing up on the shelves
<g.

Try this file:
http://www.jlathamsite.com/Uploads/I...umnsOfData.xls
that was put together with your requirements in mind. The only thing I can
think of that may break it is if you have fields that contain the semi-colon
character within them, like
1;5;Hello;6;"with a semi-colon; in it";more;last
All semi-colons are treated as field separators, so that one field would be
split into two columns, as would any others similar to it.

The workbook automatically adds enough sheets to accept the data, and will
overwrite any existing data if you reuse it -- best to either delete old used
sheets or to clear them of existing data before beginning processing.

Thanks to Chip Pearson, there's even a 'sort worksheets' routine included so
that the newly added sheets will be in the proper order to view left-to-right
to see the columns of data in the proper sequence.

Hope this makes life a little easier for you.

" 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!