Exporting using Oracle date format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cmack - 29 Nov 2005 15:38 GMT

Hello, everyone. Is there a way to force Access to use the date format that
Oracle likes (dd-mon-yyyy) when performing an export. I cannot get any other
format than mm/dd/yyyy. I am exporting to a .csv file and then loading into
an Oracle table using sql loader but it does not like the date format.

Thanks for your help.

cmack

Reply to this Message

Roger Carlson - 29 Nov 2005 16:32 GMT

OK. Don't export directly from a table. Create a query that returns all
rows from the table, but instead of your date field (let's pretend the field
name is MyDateField), have a column in your query that looks something like
this:

MyField: Format([MyDateField], "dd-mm-yyyy")

(Note: you might need to play with the format string a little.)

Signature

--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

> Hello, everyone. Is there a way to force Access to use the date format that
> Oracle likes (dd-mon-yyyy) when performing an export. I cannot get any other
[quoted text clipped - 4 lines]
>
> cmack

Reply to this Message