How to connect to an Azure CSV file with ODBC


This article provides step-by-step guidance on connecting to Azure CSV file. Below is a summary of the outlined steps in the article:



Connect with Azure Blob CSV driver in ODBC:

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

  2. Create a User Data Source (User DSN) based on the ZappySys Azure Blob CSV driver.
    Select Azure Blob CSV driver

  3. Provide your credentials, then use the Test connection
    AzureConnection Settings

  4. supply a valid CSV file path in the “Path” property in the driver configuration. You can retrieve multiple files using a wildcard (e.g., path/*.csv).

  5. If you want to use zip/GZip files, go to the Compression Zip/GZip tab and select the format you want to use.

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


This article includes screenshots for each step, providing a comprehensive guide for configuring the ZappySys Azure Blob CSV driver using ODBC. For any issues or further assistance, feel free to contact our support team via chat on our website