| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I IDENTIFY DATA THAT IS DUPLICATED IN TWO SEPERATE WORKSHEE | Excel Discussion (Misc queries) | |||
| Duplicated lines in a data table | Excel Discussion (Misc queries) | |||
| can a cell value to be duplicated to another cell during data entr | Excel Worksheet Functions | |||
| duplicated data in pivot table | Excel Discussion (Misc queries) | |||
| Duplicated data | Excel Worksheet Functions | |||
Linear Mode
