Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2004-03-25
1
788 Views
Last Modified: 2007-12-19
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
0
Comment
Question by:thoff55369
1 Comment
 
LVL 1

Accepted Solution

by:
sethspearman earned 250 total points
ID: 10678250
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question