Here's my situation.
I have an Access DB with a Query called Query1...
Query1 return 26619 records (in Access). If I export Query 1 to Excel I get the same number of records.
When I create a data connection from Excel to Access and try to import Query1 into excel I consistently get 26819 records, 200 extra records!!! I tried to create a new spreadsheet, delete the connection, refresh etc. but I does not seem to work. I wonder why this is happening... I mean it's the same query after all.
Any ideas?
Thanks
I have an Access DB with a Query called Query1...
Query1 return 26619 records (in Access). If I export Query 1 to Excel I get the same number of records.
When I create a data connection from Excel to Access and try to import Query1 into excel I consistently get 26819 records, 200 extra records!!! I tried to create a new spreadsheet, delete the connection, refresh etc. but I does not seem to work. I wonder why this is happening... I mean it's the same query after all.
Any ideas?
Thanks