MS Access Export to FTP Site

[Anon]

I am stuck. I have an Access program that pulls data from an Offline Reporting System and I need it to be able to automatically export it's output to an ftp site without any manual intervention. Does anyone know what code I can use to accomplish this??? I will be putting it in an AutoExec Macro so that it starts automatically at a certain time - but I need to figure out this export part cause it needs to run on weekends as well and I don't want to come in on a weekend! HELP! 🙂

[Anon]

I just did the same thing. Here's my process:

I used the TransferText method within Autoexec. Note - you can also customize the way your data is exported if needed. To do this, manually export the table and use the "Advanced" options when the Export Wizard appears - then save the profile. You can then specify this profile when you set up TransferText.

Then....I use the RunApp method to call a DOS .BAT file I put together - which calls a DOS FTP procedure. This is based on the
"-s" option which allows you to read all the FTP commands from a file. For example, I connect to my remote host, enter the userid and password - and then upload the data using a PUT command.

Please contact me at [e-mail] if you need any more help on this.