摘要:OpenRowSet1、向Excel查询 方法(1)select * from OpenRowSet('microsoft.jet.oledb.4.0','Excel 8.0;HDR=yes;database=D:\testdata\test01.xls;','select * from [Sheet1$] wheresnamelike ''%l%''') 方法(2)select * from OpenRowSet('microsoft.jet.oledb.4.0','Excel 8.0;H
阅读全文
posted @ 2013-01-27 19:00