INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Jobs from Indeed

VBScript import mulitple CSV files from SFTP to local drive

VBScript import mulitple CSV files from SFTP to local drive

VBScript import mulitple CSV files from SFTP to local drive

(OP)
Hello VB gurus please help me out I am new VBscript. I saw bunch of scripts on different sites but there is no straight script for me, to use. since I am not expert to modify.

I am trying to import multiple CSV files from SFTP to local drive. here is the script i copied. I don't know how far is it correct when i execute one blink of cmd window comes and go.

# Connect to the host and login using password
open sftp : //username:passsword@ftp.xx.com
# Change the remote directory
cd /Distr/Agencies/Transp/MS/EDTT
# get all the CSV files in the remote directory and download them to a specific local directory
mget *.* C:\mylocaldrive\EDTT\
# Close and terminate the session
exit

I have one more request how to frame vbscript , to export multiple CSV files from local drive to SFTP, can anyone please guide me in VBScript.

Thank you in advance.

RE: VBScript import mulitple CSV files from SFTP to local drive

What you posted is not vbscript. A google search for vbscript sftp brings up the site below. I would start there. If you are stuck, post your code and what the problem is.
https://www.example-code.com/vbscript/sftp.asp

RE: VBScript import mulitple CSV files from SFTP to local drive

(OP)
Thanks for your reply.

Yes you are correct I copied from google search and I tried to modify that. but I failed to make it run successfully. I am sorry I dont have my code.

Thank you.

RE: VBScript import mulitple CSV files from SFTP to local drive

(OP)
Hello Guitarzan,

Is there anyway can we avoid installing third-party software? ("Chilkat_9_5_0.SFtp").

Thank you.

RE: VBScript import mulitple CSV files from SFTP to local drive

Hmm i didn't notice that. I don't know if there is a way to do this natively without a third-party control. Doesn't look like it, but others may have some ideas.

Also have a look at this thread:
thread329-1476699: SFTP - secure ftp transfer using VBS

RE: VBScript import mulitple CSV files from SFTP to local drive

Windows does not support SFTP natively, I'm afraid.

RE: VBScript import mulitple CSV files from SFTP to local drive

(OP)
Thank you Guitarzan and strongm.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close