In this tutorial, we’ll guide you on how to open a CSV file from an SFTP server using the ZS ODBC Driver. Follow the steps below:
Note: You can find more information about the ZS ODBC SFTP CSV Driver here.
Prerequisites:
- Install the ZappySys ODBC PowerPack, which you can download here.
Create an SFTP CSV Driver:
-
Open the ODBC Data Source Administrator.
-
Click on System DSN or User DSN tab.
-
Click on Add to create a new data source.
-
Choose the ZS SFTP CSV Driver and click Continue the connection.
-
Fill in the required fields. In this example, we are using a local host.
-
After establishing a valid connection, select one or more CSV files from the SFTP server.
-
Now go to the preview tab and run the preview data to check the result
Now, you have successfully opened a CSV file from an SFTP server using the ZS 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.