摘要:
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 linFen 阅读(628) 评论(0) 推荐(0) 编辑