replace table with excel file

[Emma]

I would like to import data from excel into an existing table. However, I do
not want to append the data, as is done with the Docmd.Transferspreadsheet.
I would like to have the data I am currently importing, replace the old
table.

 

[Brian]

I am assuming that you do not want to replace the table (structure), but only
its contents (data). Run a delete query that deletes all the records from the
table before your run the import. This keeps the table structure intact, but
flushes the contents before the import.

DoCmd.OpenQuery "FlushThisTable"...

 

[Emma]

Worked Great Brian. Thank you,

I am assuming that you do not want to replace the table (structure), but only
its contents (data). Run a delete query that deletes all the records from the
table before your run the import. This keeps the table structure intact, but
flushes the contents before the import.

DoCmd.OpenQuery "FlushThisTable"...