Pages

Monday, March 11, 2013

How to Import the Excel Data into the MS SQL Database table


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