I created a macro in access 97 which exports a query as a text file to a directory on my hard drive. I can then use WS_FTP to upload it to a remote server. Is there an easy way to fully automate this process so that after the text file is saved on my hard drive, the file can be ftp'd to a directory on a remote server without any user intervention? I am not a technical person. Thanks.