ADO - Issue in Excel

[Kaizer]

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?

[Aflatoon]

Use UNION ALL not just UNION.

[Kaizer]

Thanks, Aflatoon. It worked.