replace table with excel file

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

Guest

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.
 
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"...
 
Worked Great Brian. Thank you,

Brian said:
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"...
Click to expand...
 
Back
Top