MS SQL Server ODBC - import Excel to SQL

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

import Excel to SQL

Vanessa

2006-01-26, 5:16 pm

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='VALUEATEXCE
L', newcol2='VALUEATEXCE
L'
where MYTABLENAME.ID = EXCEL.ID
??

Please help!

Sponsored Links