Effortless Access to SFTP CSVs: A Step-by-Step Guide for MS Access Users


This tutorial demonstrates how to connect MS Access to a CSV file using the ZappySys SFTP CSV Driver.

Note: The article provides More information about the Zappysys FTP / SFTP ODBC Driver (for CSV Files).


  • Install the ZappySys ODBC PowerPack, which you can download here.


Create an SFTP CSV Driver:

  1. Open the ODBC Data Source Administrator.

  2. Click on System DSN or User DSN tab.

  3. Click on Add to create a new data source. add a driver to user or system DSN

  4. Create a User Data Source (User DSN) based on ZappySys SFTP CSV Driver.
    Create new System DSN for ZappySys SFTP CSV Driver

  5. Create and configure a connection for the FTP/SFTP storage account.
    Create FTP/SFTP Storage Connection

  6. Select your desired single file by clicking the […] path button. You can also read multiple files stored in FTP/SFTP Storage using a wildcard pattern, e.g., dbo.tblNames*.csv.

  7. You can also read zip and gzip compressed files without extracting them using the FTP/SFTP CSV Source File Task.

  8. Go to the preview tab, select Table from Tables Dropdown, select [value], and click Preview.

Read data in Microsoft Access from the ODBC data source

  1. First, open MS Access and create a new MS Access database.

  2. Start loading the ODBC data source we created.

  3. Click next until the data source selection window appears. Select the data source we created in one of the previous steps and hit OK:
    DSN selection

  4. Continue with tables and views selection. You can extract multiple tables or views.
    DSN Table Selection

  5. Wait while the data is being loaded. Once done, you should see a similar view


You have successfully connected MS access to a CSV file using our FTP / SFTP ODBC Driver. If you encounter any issues or need further assistance, you can contact our support team via chat on our website or through email at support@zappysys.com.


For more detailed information, refer to our articles: