Automate the ftp Upload of a Comma-Delineated File
Hi Yall -
I'm not sure how, or if it's possible, but I'd like to accomplish this and don't know how:
1. create a file every night that contains all records and data from my Access db in comma-delineated format. (I guess I can loop through the recordset and output the data separated by commas - does that satisfy comma-delineated? - Then save it to the server hard drive)
2. ftp that file to an ftp server at midnight every night.
3. have the first two steps be automated somehow...
I'd really appreciate any guidance anyone can give me in accomplishing this!!!
Thanks in advance!