OK....I have a table for my Products called "tblProduct".That product has a column called 'SKU'. I have added the column 'List_Price'I have an Excel Spreadsheet that has two columns. column 1 is SKU column 2 is list_price. Can I use the import wizard to UPDATE the product table, but ONLY the column 'list_price' based on a where clause for the SKU field?I've tried walking through the wizard, but I wasn't sure how to do that.Please helpThanks!
I figured it out. Had to import to a staging table and then wrote an UPDATE statement with that where clause in it.