Help with design

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top