Can existing table data be overwritten when importing from Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to import data from an Excel (2000) worksheet into an Access
(2000) table, but I need the data to overwrite the existing details in the
Access table. I've looked on the internet and they mention that there should
be a prompt asking if you want to overwrite the details, but I do not see
this - instead, the details are appended each time. Is there a way that the
details can be overwritten?
Thanks
 
Sarah

A two-step process (if you need to replace the table contents each time):

1) run a delete query that empties the table's current rows
2) run your import/append query that loads the table with the new data.
 
Back
Top