-
ADO - Issue in Excel
Hey, I'm trying to union multiple ranges having the same structure using ADO - SQL. Just tested uniting two ranges and noticed that it doesn't pick all the lines. Identical lines that have identical values are not passed into the recordset. However when I select values from a single range all the lines are picked. Have you had similar case and what could be the workaround?
-
Use UNION ALL not just UNION.
-
Thanks, Aflatoon. It worked.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules