Exporting using Oracle date format

C

cmack

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
 
R

Roger Carlson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top