I am about to develop an Access database that will use data from a web based application. This application can export data to Excel files. I am wondering what techniques might have been or could be created to automate this process and to what extent might it be automatable. For example, could Access be coded to login to a web application to retrieve data or (only) after data has been exported to select the exported file and import into Access?
Any thoughts and ideas would be appreciated.