Excel and Access - Solution for getting data from Access to Excel and updating it easily
Budget: $10 – $30 USD
I have an Access database with four separate tables. Each of them have somewhere between 3000-12000 rows of data. I need to be able to set up an Excel spreadsheet so that it automatically retrieves the data from one of the databases (one that is selected at that time) and uses values from certain cells of the Excel spreadsheet as query parameters that give both lower and upper limits for queried values. I need to be able to easily modify these values (by modifying the corresponding cells in the Excel spreadsheet) and update the query results accordingly. I would imagine that this is not too difficult or time-consuming to do for someone who is experienced with similar tasks.