Hi, I am creating a database where most of the queries reference a statement I pull from another site once a day. All of the queries are run off of this table. When I was building it, I assumed that every day I could append over this data table with the new one I got that day. However, when I append it just adds the new information in addition to the old info. I would like all the old info to go away. I noticed that I can link an excel sheet so I could copy paste into an excel sheet every day? Does anyone have a way around this other than linking an excel sheet and copy pasting into there every day? And if that is the only way, is there an easy way to change all the queries references to this new linked sheet and replace the old one?
Kevin Robertson
@Reply 3 years ago
You can run a Delete Query to clear the table before running your Append Query.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.