vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi, I export data to an Excel file from my SQL table, added two new columns with new data to it at Excel, and now the problem is I don't know how to import/update the data back to my table at SQL using DTS Import/Export Wizard, having ID is the key. update MYTABLENAME set newcol1='VALUEATEXCEL', newcol2='VALUEATEXCEL' where MYTABLENAME.ID = EXCEL.ID ?? Please help! |