Access / FTP

[Guest]

Using VBA, I would like to FTP a file from a vendor's web site and import the
file into a table in my database.

I'm looking at 2 options: (1) create a form to display all of the files on
the site and once the user selects the file they want to process, it is
imported into an Access table OR (2) create a button for each file (4 files)
and then import the appropriate file into a specific table.

Any suggestions or examples to get me started would be greatly appreciated.
I'm a beginnier at programming in Access, so the simpler and easier would be
better (for me). Thanks for the help with this issue...........

 

[Douglas J Steele]

There are a couple of examples of using FTP from Access at "The Access Web"

http://www.mvps.org/access/modules/mdl0015.htm is a "low-tech" approach,
while http://www.mvps.org/access/modules/mdl0037.htm is a bit more
sophisticated.