duplicated external data
 

I imported an Access query into Excel, and the data gets duplicated when it
is imported. When I rerun the query in Access, the data is not duplicated -
it only happens in Excel. Any ideas as to why this might happen? I have
imported other queries without a problem

duplicated external data
 

I suspect that when you imported it into Excel, somewhere it lost the GROUP
BY portion some way or another. Have to see the SQL statements for both the
original and the imported queries to really try to figure it out.

"dany" wrote:

I imported an Access query into Excel, and the data gets duplicated when it
is imported. When I rerun the query in Access, the data is not duplicated -
it only happens in Excel. Any ideas as to why this might happen? I have
imported other queries without a problem