Append a table from access to a table in Oracle (1 Viewer)

mansied

Member
Local time
Today, 01:11
Joined
Oct 15, 2020
Messages
98
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

AWF VIP
Local time
Today, 06:11
Joined
Jul 26, 2013
Messages
9,286
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.
 

Users who are viewing this thread

Top Bottom