linked table in oracle adjusting for daylight saving

[bobmac-]

Hi,

I've linked to an Oracle table that has a date/time field of format dd.mm.yyyy hh:mm as Text.

When I display the table in Access, the Times that Australian Eastern Standard Time (AEST) apply have one hour removed i.e. 21:30 instead of 22:30.

Does ACCESS 2010 do a conversion of some sought? i.e. does it assume that the input is Standard Time so it does a conversion to daylight saving.

Thanks in advance
Bob