Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
collieraff
Starting Member
1 Post |
 Posted - 2007-05-18 : 05:30:51
|
| .. columns in SQL.HiHere's my situation. I have an existing db with a number of tables. One of the tables, tblITEMS, contains numerous part numbers and descriptions. I also have an Excel files that has updated DESCRIPTIONS and I want to import these updated descriptions into tblITEMS. Basically I want to be able to say that where the PART_NO in the Excel file and tlITEMS are the same, to import the DESCRIPTION from the Excel file and update the DESCRIPTION in tblITEMS.Thanks in advanceColin |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
|
|
sshelper
Posting Yak Master
216 Posts |
|
|
|
|
|
Importing selected data from Excel to overwrite ..