摘要：
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 IT小炸弹 阅读(158) 评论(0) 推荐(0) 编辑