Getting a List from an FTP site

  • Thread starter Thread starter Richard Krupa
  • Start date Start date
R

Richard Krupa

Hi Everyone,

Is it possible to get a directory listing off an FTP that list file names
and size so that my users can select the files and download if they wish?
Ive seen a solution for VB but not for access (and i was unable to get the
VB version to work in Access97)

Any help is appreciated.
 
Hi Danny,

Thanks for that but its not working, i think its connecting fine but hard to
say cause i get the same response no matter what user name or password i
enter. Also i cant get a directory listing, so not sure whats going on :(

Regards,
Richard


Danny J. Lesandrini said:
I used to have some code that does that. It's at my site in both a VB
and an Access version

http://www.amazecreations.com/datafast/GetFile.aspx?file=VB6Ftp001.zip
http://www.amazecreations.com/datafast/GetFile.aspx?file=A97Ftp001.zip

Comes as is with no support, but you're welcome to what's there.
Click to expand...
 
Change the server to
ftp.microsoft.com

If you're using the VB example application, then ...
Click on the first tab (CLA Download from UNIX) and hit
the Connect button. This should load a list of folders in
the listbox. Double click on a folder to load that folder's
contents.

This utility was specificially designed to download a file
for something called CLA from a UNIX server, but the code
will help you understand the commands necessary.

If you're using the Access utility, then just use the microsoft
ftp site mentioned above and click connect.
--

Danny J. Lesandrini
(e-mail address removed)
http://amazecreations.com/datafast


Richard Krupa said:
Hi Danny,

Thanks for that but its not working, i think its connecting fine but hard to
say cause i get the same response no matter what user name or password i
enter. Also i cant get a directory listing, so not sure whats going on :(

Regards,
Richard
Click to expand...
 
Ok well ive got it working so its connecting to the FTP server, only problem
is that example does not actually download the file, it says it has but
there is no record of it on my system when i do a file search. The ftp
server i need to access is a UNIX server, just wondering if i have an older
version of the control that does not support UNIX servers?

Regards,
Richard
 
Its ok, if i put the file in Capital Letters and have quotes around the path
(if the destination path has spaces) it works. Is there and update to this
control tho that fixes these issues?

Also i tried but failed downloading using the GetChunk method so can include
a progressbar on how much is left to download. Does any1 have any tips on
this? I know i can use .execute , "SIZE" to get the file size so i can set
my .Max value on the progressbar, its detecting how much has actually
downloaded that i cant seem to work out.

Regards,
Richard
 
Richard:

Glad you got it working. It's really not a control ... but rather just an
example of performing ftp from VB and/or Access. I pointed you in
that direction simply so you could see the code. Glad you were able to
get it to work for your needs.
 
Back
Top