Continuing my solved question before in this link, below is my modified recorded macro :
Please Login or Register  to view this content.
My Data2019.xlsx currently has 5 sheets and each sheets has one table :
Sheets("1901") with Table1901
Sheets("1902") with Table1902
and so on.

Each table has a column formatted as date dd-mmm-yy
and another column formatted as number with 1000 separator.

But the query result show the date column as number, something like 41717
and the other column show without 1000 separator, something like 185000

rather than to format the query result sheet by put the code before the end sub :
Please Login or Register  to view this content.
I wonder how do I retain the source data format,
so the query result sheet show the same format ?

Any kind of help would be greatly appreciated.
Thank you in advanced.