How do I query for a date in Excel VBA from an Access file

[Jonathan78]

I managed to query eveything from an access file into an excel sheet in the following way:

Please Login or Register  to view this content.

However I'd like to get only those records that have a date in field BLA4 equal to 31/12/9999

I tried the following but that did not work

Please Login or Register  to view this content.

I also tried this but again, nothing found

Please Login or Register  to view this content.

Below an example of the data:

A.jpg

The real file is a bit too complex to provide an example file.

[Jonathan78]

Already found the solution:
Replacing the apostrophe delimiter with #