sql读取excel

sql读取excel:select * from opendatasource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source=F:\test.xls;Extended Properties=''Excel 8.0;HDR=Yes;IMEX=1''')...sheet1$
原文地址:https://www.cnblogs.com/mxw09/p/2044356.html