select OrderID, CustomerID, EmployeeID, OrderDate, ShippedDate, ShipNotes
from OpenRowset(
'Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=c:/excel/Statistics.xls;HDR=YES',
O10000$)
查询Excel数据
最新推荐文章于 2023-09-06 23:29:32 发布
select OrderID, CustomerID, EmployeeID, OrderDate, ShippedDate, ShipNotes
from OpenRowset(
'Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=c:/excel/Statistics.xls;HDR=YES',
O10000$)