I have to import from time to time XLS tables to my DB (Access).
I'm using the import feature in PHPR 6.1.
I'm living in europe and my db has the date format dd-mm-yyyy.
When I import the XLS (where as well dates are formatted dd-mm-yyyy) they get obviously imported as yyyy-mm-dd.
Is there a method to import dates correctly? (the original version of my application was in ASPR and there it worked fine).
Philip