Update Table

[Jeff]

Hi,

I have a Table - "Table1" in acess. I want to import a csv file on my hard
drive and replace "Table1".

I tried --> get external data --> import

It appends the data to the table. I wanted to completely replace the data
in the table. Does anyone know how to do this?

Thanks for your help.

 

[NetworkTrade]

I've never seen an import append data to an existing table.

temporarily rename your existing Table1 to something different and try it
again....

 

[rickw]

Run a "Delete" query first, then import to your table.