SELECT
* INTO 采购入库调整
FROM OPENROWSET(
'MICROSOFT.JET.OLEDB.4.0',
'Excel 8.0;IMEX=1;HDR=YES;DATABASE=d:\中药材出入库调整明细.xls',
[采购入库调整$]
)
转载于:https://www.cnblogs.com/qanholas/archive/2011/04/19/2020723.html