I need a onclick event to do the following
Filename = orderid
Open a FTP location i.e. ftp://website.com
go to path
check if file exits orderid&".xml"
if exisits then download to local path d:\download
import xml file in to database as table
if not exist then close ftp and
msgbox "File does not exisit" <-- in access
Now I know I can creat a batch file that will run a .scr <scrtipt> file that can login to ftp etc. but how do i pass a variable from access form to a batch file....
instead of running a batch file from outside access, doesn't access have a way to access ftp itself?