Connects and extracts data from worksheets or named ranges in Microsoft Excel workbooks. Choose one of four access modes: ...

Connects and extracts data from worksheets or named ranges in Microsoft Excel workbooks. Choose one of four access modes: table or view, table or view specified in a variable, the results of a Transact-SQL statement, or the results of a Transact-SQL statement stored in a variable.