Excel File |
When you select Microsoft Excel as the Database Platform in the Add Database Connection Wizard, you must select a specific database to use with
There are two ways to select an Excel database as your data source:
Type the path of the database into the File Name field. Alternatively, you can click Browse and navigate to the desired database.
Click the Advanced button to open the Windows Data Link Properties dialog. Enter the database path and file name and/or provide the necessary security credentials to access the database. For more information, refer to the Windows' help documentation.
Once you have defined an Excel database, select Test Connection to verify that
Related Topics