Dany:
I'm not sure why you are getting the duplicates but, you don't need to
import the data. When you get your query result in Access, click the button
in the upper left corner of the result (above the rows and to the left of the
columns). This highlight the entire query result. Then right click, "copy",
go to Excel, right click, "paste". I do this all the time and never have any
problems with my data.

"dany" wrote:

Help! When I import an Access query into Excel using Import External Data,
for some reason the records are brought in duplicated (and for some records
multiple duplications). When I run the same query in Access, there are no
duplicates. Why is this happening, and how do I fix it????