Delete duplicate records in a table using a macro

[confusedtim]

I know how to automatically delete duplicate records from a table in Access manually, by copy/paste as, then use option to paste table structure only - add primary key to field you dont want duplicates in, then append original table to
new table. But I want to automate this procedure as part
of a macro. I can see the COPY and PASTE actions but can
I do PASTE AS - STRUCTURE ONLY using a pre-set macro ??

I dont know VBA yet, and will be importing text files each
day that will cause duplicate records in my access table

If you can help I would be very grateful, as Im going
round in circles and getting nowhere !!
Cheers