Using the ODBC PowerPack to connect to an Excel file

The article provides steps on how to read one or more Excel files using ODBC. Here’s a summary of the steps outlined in the article:

  1. Open the ODBC Data Source by typing “ODBC” in the search box and launching the ODBC Data Source.

  2. Depending on whether you want access for yourself or other users, go to the User DSN tab or System DSN tab. For SQL Server Integration, go to the System tab and add a new System DSN. Click the “Add” button.
    ZappySys ODBC Driver - Open UI

  3. From the driver list, select “ZappySys Excel Driver.”
    ZappySys ODBC Driver - Create Excel Driver

  4. In the driver configuration, supply a valid Excel file path in the “Path” property. You can use a wildcard (e.g., path/*.xlsx) to retrieve more than one file.

  5. Click on the “Preview” tab, select a table from the Tables dropdown, choose a column ([value]), and click “Preview” to view the data.


    .
    The article provides screenshots for each step to guide users through the process of configuring the ZappySys Excel Driver using ODBC for reading Excel files. If you encounter any issues or need further assistance, feel free to contact our support team via chat on our website or through email at support@zappysys.com.