FTP Text File to a UNIX Server using VB Code in Access 97

I have code that is creating a text file that I need to FTP to a UNIX server and I want to do this using VB code so it can run over night when the network traffic is low.  Does anyone have code that will grab the file that I create on my local drive and FTP to a UNIX server!?!?!   Thanks
thoff55369Asked:
Who is Participating?
 
sethspearmanConnect With a Mentor Commented:
First create a command line FTP script as follows and save it as ftpscrpt.txt:
OPEN MYFTPSITE.COM
USER MYUSER MYPASSWORD
ASC
CD orders  'change to the directory if you need to.  remove this comment from actual file.
PUT MyData.csv
DISCONNECT
QUIT

create a batch file that executes this FTP script as follows and save it as MyBat.bat:
@ECHO OFF
ftp.exe -v -n -s:ftpscrpt.txt
EXIT

From your VB code execute the batch file as follows:
Call ShellWait("MyBat.bat", vbHide)

Seth B Spearman

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.