摘要:1.insert into tbProduct (ID,UserID) select A,B from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="D:\DLL\tbProduct.xls";Extended properties="Excel 4.0;HDR=Yes"')...[sheet1$]go2.启用Ad Hoc Distributed Queriesexec sp_configure 'show advanced options',
阅读全文
posted @ 2012-09-08 11:52