replace table with excel file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Emma - 02 Aug 2005 01:11 GMT

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.

Reply to this Message

Brian - 02 Aug 2005 05:51 GMT

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"...

> 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.

Reply to this Message

Emma - 10 Aug 2005 00:24 GMT

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
[quoted text clipped - 7 lines]
> > I would like to have the data I am currently importing, replace the old
> > table.

Reply to this Message