Access 2003 creating Text file(s) as FTP Scripts

AndyJB · 15-07-2008 02:52PM #1

Hi All,
I'm running Access 2003 to generate CSV files which is working fine. I'm then running FTP via "Call Shell" and using a pre-existing FTP script file to send my files to a remote FTP server.

The above works fine, but I would like to be able to reference a unique file name per FTP Script that's run, as the fixed FTP script leaves me open to data file lose.

I have tried "DoCmd.TransferText acExportFixed...." but the text file generated has a fixed line width and FTP doesn't like these.

Any ideas will be much appreciated.
Regards,
AJB

PS If you know of any smarter way to run FTP from within Access that would be a bonus and also very much appreciated. The Call Shell process is weak on error handling/status reporting. In fact it has none!

muminek · 25-07-2008 12:53PM

Hi AndyJB,

I had similar problem few weeks ago - what I was told by one of IT guru was to use Perl and "use Net::FTP" commends.

It was quite easy to write the code in Perl (15 line only) - but it worked. Plus Perl forums are full of scripts to use.

Hope it will help,

m

sicruise · 25-07-2008 01:17PM

You could create a batch file to perform your ftp upload and use the current datetime as a timestamp and append a log file each time the process runs.

Add this batch file to your scheduler and get it to upload a file if it is present in the folder.

This way access will just be creating the file.

You can log an error if it occurs.

Access 2003 creating Text file(s) as FTP Scripts

Comments