Reading data from FTP server

[Guest]

I've been asked to write an application that reads data from an FTP server.
This server is proteced by userid/password. Can this be done from Access? The
data is a comma-delimited text file and will be imported into Access which
will be used as a reporting tool. The data is downloaded from a mainframe
system on a periodic basis each file having a different name. I really think
this should be a web application based on SQL Server but they want it done
ultra-quick hence the request for MS Access. Any help appreciated. Thanks -
David

 

[Joe Fallon]

Access can do anything that VB can do.
There is no built-in FTP control in Access.

You can use code like this to implement FTP in Access:

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

I use the above code in one of my apps and it works fine.
It basically allows you to call the ftp executable and run a script of
commands.

If you have VB6 you can add the InetControl (?) to an Access form and it
works easily.

 

[Guest]

I'm hitchiking on someone else's thread here, their problem is so very
similar to mine!

Joe- I downloaded the add-in from your website however I'm running Access
2002 and it's telling me that the add-in is from a previous version of Access
and I should obtain a new version from the provider of the add-in then it
exits add-in manager without adding it in!

My file is also a text file that is out on the company intranet, file
extension .csv. I got to a point in "Link Tables" where I found the file on
the server, but it gives me the error, "Internet Login Failure" when I click
the link button. I've attempted to map the drive and have entered my user id
and password but it still fails.

Can you provide assistance, or an updated version of the add-in?

Thanks in advance for any help you can provide.

Monique

 

[Douglas J. Steele]

There's no add-in on the page Joe cited (FWIW, it's not his site), so I have
to assume that you followed the link at the bottom of the page to
http://www.mvps.org/access/modules/mdl0037.htm

Go back to that page and read the 3rd paragraph (the underlined one)

 

[Guest]

There is, in fact, an add-in on that page. There's a download that contains
a sample database and the add-in. Tried following the instructions but the
code written on that page references something that cannot be done without
the add-in available for download and in access 97 format.

Excuse me for being stupid, but I don't understand what the underlined
paragraph is telling me to do, especially considering I'm unable to use the
add-in with access 2002. If 2002 doesn't recognize the add-in, how can I
import from it?

Guess I'm just a bit impatient and feel this should be a lot easier. By the
tone of your note, I guess you're fairly impatient, also.

Monique

 

[Douglas J. Steele]

What the underlined instructions mean is open your database in Access 2002.
Go to File | Get External Data | Import on the menu bar. Navigate to the
downloaded MDA and select it. You'll be presented with the details of what's
in the addin. Select all of the classes from it (they'll be on the Modules
tab) and import them into your application.

(And, FWIW, the add-in is NOT on the page Joe cited. When you clicked on the
hyperlink at the bottom, you were taken to
http://www.mvps.org/access/modules/mdl0037.htm, which is where the add-in
is)

 

[Guest]

Thanks for educating me.

"(And, FWIW, the add-in is NOT on the page Joe cited. When you clicked on the
hyperlink at the bottom, you were taken to
http://www.mvps.org/access/modules/mdl0037.htm, which is where the add-in is)"

Well, heck. That's just splitting hairs.