How To Use ADO with Excel Data from Visual Basic or VBA

The Jet Provider requires only two pieces of information in order to connect to an Excel data source: the path, including the file name, and the Excel file version.

support.microsoft.com