I am currently attempting to import data from a zip/compressed file that is transferred to us from a vendor through an SFTP site. When I download the zip and extract the file, it is a CSV file and utilizes UTF-8 encoding which will import as expected. When I connect to the zip/compressed folder, the data is imported in an encoding that results in symbols being imported. There are so many different types of encoding to choose from, does anyone know the most common forms that I could try to facilitate the proper import of the data directly from the zip folder?
Thank you in advance for your help.