SQL，C#查询Excel数据

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=D:\Book.xls;Extended Properties=Excel 8.0;HDR=YES;IMEX=1', 'SELECT * FROM [Sheet1$]')IMEX=1：查询数字是出现Null，添加这段。-----------------------------------http://www.cnblogs.com/goto/archive/2012/04/12/2443670.html于E