Connecting to Excel Workbooks

The SaveToDB add-in enables you to connect to data in Excel workbooks.

Supported data providers for the SaveToDB add-in include:

• Microsoft Excel Driver
• Microsoft.Jet.OLEDB.4.0 (32-bit only)
• Microsoft.ACE.OLEDB.12.0
• Microsoft.ACE.OLEDB.16.0

Below is a sample of the Database Connection Wizard page where you can choose your data provider:

Next, select a workbook:

Then, choose a named data range or a worksheet to connect to: