I would like to create an automated method of sending a custom data report(s) using an ms access database to my ftp site on a scheduled basis. My database is saved as a .BAK but can be opened in MS Access as a .mdb. The database is comprised of 50 tables from which have different sets of information I need extracted into a customized report (.csv). This report needs to be scheduled to send the .csv files to a sftp site on a routine basis (nightly). This whole process needs to be fully automated. This will likely require the use of Access macros, Windows scheduler, and 3rd party software (Crystal, MARs, etc.). The report will be simple (15 field descriptions) however I need a real MS Access expert!