select RouteName,RouteStepName,OperationName from (SELECT *
FROM OPENDATASOURCE( 'Microsoft.ACE.OLEDB.12.0', 'Data Source="D:\Book1.xlsx";User ID=Admin;Password=;Extended properties=Excel 12.0')...[Sheet1$]) T本文共 212 字，大约阅读时间需要 1 分钟。
select RouteName,RouteStepName,OperationName from (SELECT *
FROM OPENDATASOURCE( 'Microsoft.ACE.OLEDB.12.0', 'Data Source="D:\Book1.xlsx";User ID=Admin;Password=;Extended properties=Excel 12.0')...[Sheet1$]) T转载地址：http://tanoa.baihongyu.com/