Enter username/password into a pop up outside of Access?

[JP Romano]

Hi... I'm trying to automate a process for grabbing files from an FTP site, unzipping them, and importing the data into an access db.
I've not been able to get the string to work using the standard "Usernameassword@hostname.path" approach (or any variations).
So, I'd like to open the ftp site and log on in two steps. The first is easy enough - but when I get to the site, I get a pop up for username and password (via Internet Explorer).

Is there any way to get to the pop up?
FYI, the users do not have any sensitive data on the ftp site and are not concerned with passwords in plain view. I know...

Thanks for any help!

 

[gemma-the-husky]

i'm doing this - i assemble a script to run ftp from a command prompt, then run the script - i'll post it when i get a moment

only problem is im using execcmd to run the script, which it runs in a command window - i would prefer to do this invisibly, but i cant find a way.

[edited]
eg the file looks like this - this collects a simple file listing from the site

OPEN ftp.mysite.co.uk
USER FRED FREDSPASSWORD
cd \whateverpath
lcd c:\localpath
ascii
ls * FTPXfer.txt
prompt
mget *
bye

 

[JP Romano]

Thanks Gemma...or Mr. Husky
I'll give it a shot. If I come up with anything, I'll let you know as well. Seems like this should be a bit easier to accomplish!

 

[Banana]

If you want to have more functionality and an interactive session, it may be easier to use a DLL to manage the FTP connection: Here's a DLL to try out.

Gemma's script is definitely easier, though.

 

[pbaldy]

I also use a batch file for automated FTP downloads, but there's also this which I didn't know about when I created the batch file, so don't know if it's better/worse:

http://www.mvps.org/access/modules/mdl0037.htm

 

[Banana]

Cool, didn't know they already had a example, using the same DLL even!

Thanks for that link, pbaldy.

 

[JP Romano]

Wow..thanks for all the feedback!
So far I'm not having much luck, but that's likely due primarily to my own ignorance. Fortunately, nobody around me here has any programming experience, so the little I have gives me enough ammo to keep them at bay while I investigate and learn!

 

[shadow9449]

Hi... I'm trying to automate a process for grabbing files from an FTP site, unzipping them, and importing the data into an access db.
I've not been able to get the string to work using the standard "Usernameassword@hostname.path" approach (or any variations).
So, I'd like to open the ftp site and log on in two steps. The first is easy enough - but when I get to the site, I get a pop up for username and password (via Internet Explorer).

I've had a lot of success using wget with Access. You don't need to use FTP for it - you can just host your files on any server and download using HTTP. Here's a link to the documentation. And by the way, it's free.

http://gnuwin32.sourceforge.net/packages/wget.htm

Let me know if you need a hand implementing it.

SHADOW