I am trying to automate the import of delimited .txt files generated
by FrontPage forms on a Web server.  I can set up and logon to the FTP
site using the Import Action and adding the FTP site to the "FTP
Locations", but when I try to import the files I get the error "Path
not found".

Documentation says that text transfers are not supported by the Import
Action (Thanks Uncle Bill) and to try the "Transfer Text" method.  I
can get this to work via code or macro as long as I am doing it on my
local web server without subdirectories or security, but cannot get it
to work from the remote server.

I've also tried to create an DOS import batch file to import the files
specified using command line FTP with no success.  If I can find a way
to do so, I can always generate a .bat file from code to do this, but
can't find enough command line FTP documentation to accomplish this.

Just installed VB5 too, but am a novice...would it be possible to
create an executable, ActiveX control, etc. to accomplish the same
thing?  I would just have my users use a normal FTP program, but even
simple e-mail seems to baffle them...<sigh>

Any thoughts would be greatly appreciated.

Gerry

Which Command line FTP are you using?  If it's the one that comes with Win95
then you can get most of the information you want by:
    1) Going to the command prompt and typing FTP -? (This will give you the
command line options)
    2) Starting the program and typing ? at the prompt. (this will give you
the in-program commands)

I have used this program to transfer files in a number of projects and have
not had any problems with it, essentially you create a script file and then
start FTP with the -s switch pointing at the script file.

Below is an example script file (C:\MS.SCR) which can be used with Win95
FTP.
'***************  Script Start  ******************
lcd "C:\Program Files\MPS\MsFiles\Access95\Download"
open ftp.microsoft.com
anonymous

cd \softlib\mslfiles
binary
get AUT97.EXE AUT97.EXE
bye
'***************  Script End  ******************

To run this from Access I would use a command such as this

    dim strCmd as string
    strCmd = "c:\windows\ftp.exe -s:C:\MS.SCR"
    call shell(strCmd,vbHide)