Exporting using Oracle date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.)

--
--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
 
Back
Top