Append a table from access to a table in Oracle

[mansied]

Hello
I really need a help
I have a table in access in which two fields are date/time datatype .when I change it to shortime to append to a oracle table( two fields type are VARCHAR2(5byte) ,it doesn't let them in .
ex:
from Access ( 4:30:20) Am doesn't get in ...because should be 04:30:20 Am
when I change the datatype to short text it is ok but the time is not 24h anymore.

no idea how to change it .....any perfect idea ..( no access to change the oracle data type )

 

[Minty]

If the destination fields are a Varchar then you need to pass a string surely?

Try format([YourField],"hh:nn:ss")

Should format the time in 12-hour format, however, for some reason, it doesn't add the AM and PM.... Which according to the Access help pages it should.