Thanks for the reply.
I apologize for this long-ish post.

I cannot offer out any data (of course) and I do not know where to start
with the code. I guess I'm a total noob. The code I have is snippets
collected of the web trying to be able to load the file into a single
workbook(multiple sheets). There was the one on the MS site that drops all
of the text into one column then needs to be split out with the text to
columns tool - takes about 10 minutes per sheet. then there was a splitting
tool that breaks the CSV file into smaller chunks so you can directly import
each one into a worksheet. These get me started and I can do the rest
manually, but that takes about an hour or so to get the whole thing done. I
guess I do not know where to start to get the process automated. Other
searches on the net don't seem to pull anything up. Perhaps I am not looking
in the right place or for the right thing.

With that said, the data can be sorted by a particular column denoting the
location that I am at. This is the 15th column in the CSV data file and I
would like to load only rows that are positive for this one field. The
overall size of the source CSV file is in excess of 100MB so anything i do on
the entire files will take more than a few minutes. If I could get this
working, the data I need will fit in one sheet.

I'm handicapped in this process of learning what I need by some of the
policies in effect at my workplace - no paper (so no books) no data transfer
mechinisms (USB keys and such) so I cannot work the issue at home where I
have the resources.

I realize this makes it more difficult to help me and I am sorry. I'm not
sure what else to offer though.

Steve
(Appreciatng you time very much - thank you)