I have a performance problem where I need to import a 36mb csv into a new csv file.

The csv has 6 fields; isbn(char), whse(char), stock(int), backorder(int), discount(char), price(float)

There are four possible values for the whse. I need to merge the data into an unique isbn, stock, backorder, discount, price

What I have been trying to do is parse the rows thru the fso and set the whse and stock fields into arrays. Then write the row to the new file.

Does anyone know of a better solution?

Thanks,

Howard