Another method without using the dts package
IF OBJECT_ID('tempdb..#temp')is not null
DROP TABLE #temp
create table #TEMP ( PK int, received datetime)
insert into #temp
SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=c:\UrExcelFile.xls;Extended Properties=Excel 8.0')...Sheet1$ -- put ur excel filename and sheetname
Update urTable
set received =t.received
from aaa
inner join #temp t
ON urTable.PK = t.PK
DROP TABLE #temp
Ads 720 x 90
Total Pageviews
Label List
- Architecture
- Art of SQL Server
- asynchronous mirroring
- csv
- dmv
- find outdated Statistics
- Free SQL Server tools
- index fragmentation
- Installation
- Katmai
- Learn SQL Server 2005
- Maintenance Plan
- outdated Statistics
- Reset Identity column
- Scripts
- SPID
- sql server 2008
- sys.dm_db_index_physical_stats
- sys.dm_exec_connections
- tsql
- update statistics