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$
posted @ 2011-05-12 14:37  再快一点  阅读(302)  评论(0编辑  收藏  举报