Returning results of query in custom data types

Hi all,

I am using below query to get data from Access and paste it into Excel worksheet. When data is transferred back to Excel it does not have correct date data types. For all cells in the column I need to double click and confirm and it changes to date format. I tried to use loop macro that would do this with every cell, but it takes around 8 minutes for 2,500 rows which is too long. Is there any other way to return certain columns with date format?

Please Login or Register  to view this content.

@oeldere thanks for your reply, but unfortunately this does not change the value inside each cell to data format..

The code itself executes without an error, however none of the cells are changing format. It is exactly same behaviour I get when trying to achieve this with manual intervention. Since trying your solution I have checked result I will get by using power query for ms access connection and changing data type there. This seems to be doing the trick however I am still in process of testing whether this is the best solution performance wise. I will post an update when I am done