Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Update fields in SQL table from Excel spreadsheet
Example data in the spreadsheet:
wh product ****1 ****2 ****3
BG 123456 ABC BCD CDE
FE 234567 ACB BCD DEF
GR 345678 ABC BCD CDE
I know how to import the spreadsheet to a temporary table if that would help, but the update query is the part that I can't figure out.
I'd be grateful for any help at all.