|
Replies:
1
-
Pages:
1
-
Last Post:
Sep 10, 2011 10:43 AM
by: DarkMagneto
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
2
Registered:
9/2/11
|
|
|
|
Import Wizard help needed
Posted:
Sep 2, 2011 12:54 PM
|
|
|
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 help
Thanks!
|
|
|
Posts:
2
Registered:
9/2/11
|
|
|
|
Re: Import Wizard help needed
Posted:
Sep 10, 2011 10:43 AM
in response to: DarkMagneto
|
|
|
I figured it out. Had to import to a staging table and then wrote an UPDATE statement with that where clause in it.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
