i have an excel table with dates in french (i.e. 27-févr-01),i tried changing it to english by changing the format and it didn't work. is there a way to do this? thanks.
hi,
i have ACCESS tables that are linked to oracle database and the queries with dates will not execute. i put hard brackets around the date in the sql script, yet a pop up window still asks for the date when i run the query:
SELECT SURGERY.PTID, SURGERY.PTINIT, SURGERY.SURGDATE
FROM SURGERY...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.