How to replace old data with import Excel data?

[aska]

Hi, i am a new comer. i have a table for students' comment for the first semester. however, in the 2nd semester i want to replace them with import data from excel to this table, but on the same student there are 2 rows of records (1 is 1st semester and 1 is 2nd semester).

how can i replace the new data to the old data? or how can i delete all the old data in the exsiting table so that i can import a new excel file?

thx

 

[The_Doc_Man]

A DELETE query can leave a table empty but structurally intact.

Do the DELETE first. Then import your data and choose the option to append to an existing table.