Can I FTP a text file created by Access, to an FTP server

[Ken]

I used the TransferText method, in Access 2002, to create a text file from a
table, on my harddrive, Can I now set up an FTP instruction from within
Access to send the file to a FTP server.

 

[BeWyched]

I don't think that there are specific commands within Access to do this.

However, I have done it by getting VBA to create a batch file which triggers
your FTP client then transmits the file (look in Windows Help files for the
commands), then launching it using the Shell command.

A better option I found was to buy in an VBA programable FTP client in the
form of an ActiveX control. I bought in one from www.evansprogramming.com
which is great. I can't remember what it cost but it wasn't a lot.

Hope this helps.

BW

 

[Jesper]

I used the TransferText method, in Access 2002, to create a text file from

a
table, on my harddrive, Can I now set up an FTP instruction from within
Access to send the file to a FTP server.

This article helped me a lot
http://www.databasejournal.com/features/msaccess/article.php/3513061

Jesper

 

[pietlinden]

I used the TransferText method, in Access 2002, to create a text file from a
table, on my harddrive, Can I now set up an FTP instruction from within
Access to send the file to a FTP server.

did you look at this:
http://www.mvps.org/access/modules/mdl0037.htm

I would check Randy Birch's site too. (nope, not there...)

 

[Ken]

Thank you all, I will study these new sites, and scripts, but it is nice to
know there is a possibility for this. I really appreciate your replies.
Ken