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
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