Hi, I have a database I'm working on, that I inherited, and suffice it to say, there is a database (that we don't own) that we draw data from in the form of an Excel spreadsheet, and then import it into our own Access 2007 database using the import function. We've got it as a saved import, so it isn't terribly difficult. The data goes into a table called "new tasks". We then run an append query, the data is sifted by several embedded queries, and the result is that the newly imported data is checked for duplicates and then appended to our main "tasks" table, including several new columns and such that the original data does not have (which is the reason I guess the designer was forced to import into a separate table).
What I'd like to do is find a way to modify the append query to then wipe clean the "new tasks" table. How do I do this?
What I'd like to do is find a way to modify the append query to then wipe clean the "new tasks" table. How do I do this?
