Search results

Actually no one inputs data into the main spreadsheet. The data is compiled automatically. I just query the data and arrange it into excel first. Thanks,

This may indeed work, but I want to get away from having to validate or even look at the query's results. Thanks for the response.

Hello Everyone, I am in the process of trying to automate a daily task of appending data from my excel file (which is already automated) into my access database. I was able to use SetWarnings to make the database ignore the first onscreen prompt. The issue I am having now is I have not...