Help with design

[Guest]

I will have a comma delimited csv file ("" around the text fields seperated
by comma) that I want to put into different work sheet based on product code.
Each product code will get it's own worksheet. I do not know how many unique
product codes there will be, but say not more than 30. The csv file will be
too large (more than 65k rows) to import directly into Excel. But each
product code will have less than 65k rows.

How do I start on this project. Guess the incoming file could already be
sorted on product code. I need some VB code to import the file into a
worksheet, when there is a break (change in value) on the product code, then
start inserting into a new worksheet. Can anybody help me get started?

Excel 2002 SP-2

Thanks

Brenda

 

[Guest]

Do you have MS Access. If so we can import the data int MS Access, and
retrive the data from Access via a pivot Table. That will get you around the
whole 65,000 rows thing and gets away from the coding. Trust me when I say
that this way will be much easier (if we can do it), and a whole lot more
powerful in terms of data presentation and analysis.

HTH

 

[Tom Ogilvy]

Jim make a good recommendation, but if this is not a feasible path, then you
can get started with Chip Pearson's site. You can modify these macros to
look at the product code and perform the actions you desire.

http://www.cpearson.com/excel/imptext.htm#Import