This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am getting a message when trying to overwrite the data I have in Access 2010.
I have imported an Excel worksheet into Access and have made updates to the worksheet and re-imported the worksheet into a table many times over the last month. Today when trying to import the worksheet following the same steps I am asked if I want to overwrite and I select yes, then the next pop-up says "Can't overwrite table or query ...". No error message or indication why or where to go look.
What changed?
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I already know that I can't import/overwrite when the table is already open in Access.
I've also checked all my columns in the worksheet to see if the match the rows(records) in the table, they do.
Do you have it open? Open could be a form or just a query showing the data.