Read an FTP Log File

  • Thread starter cableguy47905 via AccessMonster.com
  • Start date
C

cableguy47905 via AccessMonster.com

I need to see if I can have Access open an FTP.log file as read only and then
pull in the data and parse it out into different fields. I have a couple of
problems.

I can't really write VBA code. (I can usually manipulate someone else's code,
though.)

The file is an appending file. Meaning, for every new FTP connection, it is
appended to the end of the file.

The entries are not really very unique. I will include sample.
I only need specific data, like date, userID, filename, dataset, and status
(successful or not).

This is a pretty big project for me and quite frankly beyond my VBA skills.

Would anyone be able to provide a sample or general direction as to where
else to look for assistance?

Thank you,
Lee
 
C

cableguy47905 via AccessMonster.com

Here is a sample of the file:
====================Start of download===================
Connected to mvsftp.mf.MYWEBSITE.com.

220-FTPD11 IBM FTP CS V1R9 at MVSE.MYWEBSITE.com, 11:34:31 on 2008-11-20.
220 Connection will close if idle for more than 5 minutes.
User (mvsftp.mf.MYWEBSITE.com:(none)):
331 Send password please.

230 I554123 is logged on. Working directory is "I554123.".
ftp> quote site lrecl=25000 recfm=vb
200 SITE command was accepted
ftp> Local file Remote file PUT
illinois.txt
'fle3.cgs.pn.erftp.upload.M399CMU'
200 Port request OK.
125 Storing data set FLE3.CGS.PN.ERFTP.UPLOAD.M399CMU
250 Transfer completed successfully.
ftp: 4861 bytes sent in 0.00Seconds 4861000.00Kbytes/sec.

ftp> close
221 Quit command received. Goodbye.
ftp> Bye
---------------------End of download-------------------
 
Top