Johnny B
09-14-2008, 03:42 PM
Hi all,
I have a fairly simple issue here, I think, but after some searching, haven't found exactly what I'm looking for. I should say that I do have some experience with VB .NET, but none at all with Excel macros.
I have a .csv file from a vendor that contains product data for all of their products. I do not want all products imported into my database, and I have a list of product ids for the products that I do want imported. Therefore, what I want to do is compare the product_id column from each workbook and delete those rows (from the vendor's workbook) which do not have a matching product_id. Again, I'm sure this is quite simple, I just have no idea how to go about accomplishing it.
Any help is greatly appreciated. Thanks!
I have a fairly simple issue here, I think, but after some searching, haven't found exactly what I'm looking for. I should say that I do have some experience with VB .NET, but none at all with Excel macros.
I have a .csv file from a vendor that contains product data for all of their products. I do not want all products imported into my database, and I have a list of product ids for the products that I do want imported. Therefore, what I want to do is compare the product_id column from each workbook and delete those rows (from the vendor's workbook) which do not have a matching product_id. Again, I'm sure this is quite simple, I just have no idea how to go about accomplishing it.
Any help is greatly appreciated. Thanks!