Can existing table data be overwritten when importing from Excel?

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
 
J

Jeff Boyce

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link or Import Data from Excel to Access 2
Importing data (beginners guide) 3
Importing into a table 1
Importing data from Excel into an existing Access table? 1
Problems Importing Excel Files to an Existing Table 1
Importing Excel Data into MS Access Table 1
Import errors importing Text into existing table, header vs no hea 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Top