Bạn dùng thử đoạn này nhé, chỉ dùng cho excel 2003 trở về trước nhé. Chúc thành công
DECLARE @RC int
DECLARE @datasrc nvarchar(4000)
DECLARE @server nvarchar(128)
DECLARE @srvproduct nvarchar(128)
DECLARE @provider nvarchar(128)
DECLARE @location nvarchar(4000)
DECLARE @provstr nvarchar(4000)
DECLARE @catalog nvarchar(128)
DECLARE @_StrExec nvarchar(4000)
SET @datasrc = 'D:\Excel\Test.xls'
SET @server = 'Db_Xls'
SET @srvproduct = 'Excel'
SET @provider = 'Microsoft.Jet.OLEDB.4.0'
SET @provstr = 'Excel 8.0'
IF EXISTS (SELECT srv.name FROM sys.servers srv WHERE srv.server_id != 0 AND srv.name = N'Db_Xls')
EXEC master.dbo.sp_dropserver @server=N'Db_Xls', @droplogins='droplogins'
EXEC @RC = [master].[dbo].[sp_addlinkedserver] @server, @srvproduct, @provider,
@datasrc, @location, @provstr, @catalog
IF Object_Id('Tempdb..#TbTmp') IS NOT NULL DROP TABLE #TbTmp
SELECT * INTO #TbTmp FROM Db_Xls...[SHEET1$]