remove dupes in fields via VBA

[sal21]

Have:
mymdb.mdb
mytable
myfiledname

how to remove from field myfiledname all duplicates records?

note: i want to use in VBA for Excel.
Tks.

[asingh]

Hi,

You want to do this in Excel, or in Access. If in access it can be done using normal queries..why go for VBA........?

[sal21]

Hi,

You want to do this in Excel, or in Access. If in access it can be done using normal queries..why go for VBA........?

I use Excel and VBA in my project... and i want to integrate a new macro to delete dupes in table of mdb in this project...
Tks.

[asingh]

You could do it by normal queries. Using a simple SELECT query with DISTINCT. "SELECT DISTINCT field_name FROM table_name"

Or you could do a group by similiarily...which would again remove duplicates..