Hi,
I am writing to a text file the records in an access table that is to
be loaded into an Oracle system.
However, I have been told that the date fields in the records I have
exported to the text file that are not compatible with oracle. The
format looks like: 01/01/2006 and I need it to look like 01-JAN-2006.
I have tried using the format function and the variable still shows it
as 01/01/2006.
The text file is generated by clicking from a button on a form which
contains the string/date variables and a loop with the write lines. I
am not on my work PC at the minute so can't show what I've created, but
can post it later if needed.
Can anyone give me an idea of how to get this sorted.
Cheers.