I know this is probably a stupid question, but I'm not sure if it can be done. I want to be able to import Excel spreadsheets and have Access extract information from only specific columns for reporting. I'm able to do this with Queries and then run reports based off those Queries.
However, the table data is going to change. One week I might be working with one set of Excel data and the next week it may change. The only thing I can think to do is keep the Queries and Reports in the database and then delete the tables and import the new Excel data to new tables and rename those tables to exactly what the old tables were called (so the Queries and Tables will still run). All the columns will have the same names, but the data in the rows will change... Is there a more automated way I can do this w/o having to go in and delete and re-add tables of new data?
However, the table data is going to change. One week I might be working with one set of Excel data and the next week it may change. The only thing I can think to do is keep the Queries and Reports in the database and then delete the tables and import the new Excel data to new tables and rename those tables to exactly what the old tables were called (so the Queries and Tables will still run). All the columns will have the same names, but the data in the rows will change... Is there a more automated way I can do this w/o having to go in and delete and re-add tables of new data?