duplicated external data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top