sqlserver openrowset,opendatasource,openquery

1.openrowset

INSERT INTO dbo.ImportTest 
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
'Excel 8.0;Database=C:\ImportData.xls', 'SELECT * FROM [Sheet1$]') WHERE A1 IS NOT NULL

2.opendatasource

INSERT INTO dbo.ImportTest 
SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 
'Data Source=C:\ImportData.xls;Extended Properties=Excel 8.0')...[Sheet1$]

3.openquery

EXEC sp_addlinkedserver 'ImportData', 
   'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 
   'C:\ImportData.xls', 
   NULL, 
   'Excel 8.0' 
GO

INSERT INTO dbo.ImportTest 
SELECT * 
FROM OPENQUERY(ImportData, 'SELECT * FROM [Sheet1$]')