MySQL Forums
Forum List  »  MySQL for Excel

Excel bamboozelry
Posted by: Matthew Jaramillo
Date: November 14, 2012 08:39PM

I have searched high and low and have not found a great answer. Maybe someone here can assist?

The low-down:

CSV file database export with category names from my ecommerce site.

column 1 (Name) column 2 (ID)
super soakers 153
shoes 188
bottles 297

CSV file import file

column 1 (ID) column 2 (product name)
super soakers Big Super Soaker
shoes Black shoe with no laces
bottles Jim Beam Bottle

The need:
I need for file 2 (the import file) to know and change the value of column 1 to be the value of column 1 in the file 1 (export file) so that the 5k products that I have with over 200 categories can be done in one quick swoop.

ideas?

I'm willing to create random columns with the column 1 and 2 from file 1 into file 2 just so I dont have to search in other sheets or files.

The outcome (import):
column 1 (ID) column 2 (product name)
153 Big Super Soaker
188 Black shoe with no laces
279 Jim Beam Bottle

Options: ReplyQuote


Subject
Views
Written By
Posted
Excel bamboozelry
1631
November 14, 2012 08:39PM
802
December 07, 2012 04:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.