Create a Dummy table name is Dummy_Tyring and create column name as per Excel Sheet.
The existing table name is Properties
steps:
1.Just copy all data from Excel File and paste into the Dummy_Tyring table
2.Execute the below update Query
update [Properties]
set [Properties].Tiring = Dummy_Tyring.Tiring
FROM [Properties]
INNER JOIN Dummy_Tyring ON [Properties].PropertyPIN = Dummy_Tyring.PIN
3.Now all the dummy data information has moved to Existing Database table.
No comments:
Post a Comment