quote:

---

Create linked server to Excel File.

sp_addlinkedserver N'Excel', N'Jet 4.0',

N'Microsoft.Jet.OLEDB.4.0',

N'c:\data\MySheet.xls', NULL, N'Excel 5.0'

GO

sp_addlinkedsrvlogin N'Excel', false, sa, N'ADMIN', NULL

GO

And run query as following.

delete account

where acct_id IN (SELECT ColumnA FROM [FROM EXCEL...Sheet1] where ColumnA = 1000)

---