How can we import .xls files into ssms and only those items must be copied in to the database which are new and the old must be deleted automatically?

Question

I need to import excel files into SQL server 2008 SSMS manually and only load those items into the database which are new not the existing ones. please find me SQL Query for the same.

score 1 · Answer 1 · edited May 23 '17 at 12:27

1

I would suggest that you can use SSIS in this situation. I guess there is no straight forward query to handle this situation. First you need to load data into the staging table and then you have to move the new records only. Please refer here for T-SQL command Import Excel spreadsheet columns into SQL Server database

edited May 23 '17 at 12:27

Community

1
1

answered Jul 12 '12 at 07:00

sganesh

89
6

good and detailed answer.. upvote! – Shezi Jul 16 '12 at 07:09

score 0 · Answer 2 · answered Jul 12 '12 at 06:54

0

You can use OPENROWSET function shown here http://beyondrelational.com/modules/2/blogs/70/posts/10846/export-to-excel-with-column-names.aspx

answered Jul 12 '12 at 06:54

Madhivanan

13,244
1
23
28

Hey man i wanted importing data not exporting... – SuperSonic Jul 12 '12 at 09:17

How can we import .xls files into ssms and only those items must be copied in to the database which are new and the old must be deleted automatically?

2 Answers2