<div>
Yes, MySQL, not MS SQL Server.<br />
<br />

</div>


<div>
Oh....OK, I can import to a staging table....but how would I write the UPDATE statement on the join? &nbsp;Can you give me an example?<br />

</div>


Oh....OK, I can import to a staging table....but how would I write the UPDATE statement on the join?  Can you give me an example?


<div>
Thanks so much for your help! &nbsp;That worked perfect! &nbsp;I imported to the staging table and then ran the update statement! &nbsp;Thanks so much!
</div>


Thanks so much for your help!  That worked perfect!  I imported to the staging table and then ran the update statement!  Thanks so much!

<div>
<div class="content wysiwyg-content">
OK....I have a table for my Products called &quot;tblProduct&quot;.<br />
<br />
That product has a column called 'SKU'. &nbsp;I have added the column 'List_Price'<br />
<br />
I have an Excel Spreadsheet that has two columns. &nbsp;column 1 is SKU column 2 is list_price. <br />
<br />
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?<br />
<br />
I've tried walking through the wizard, but I wasn't sure how to do that.<br />
<br />
Please help<br />
<br />
Thanks!
</div>
</div>


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!

Help with Import Wizard

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.