5 pts.
 Exporting MS Access data to Oracle
Hi, I am exporting MS Access tables to Oracle using ODBC. I face MS Access 'Overflow' error for the tables which has date/time fields and has values in the format MM/DD/YYY. The error happens for only some of the data, for example 10/15/101. Please provide suggestions for how to solve this error. Thanks.

Software/Hardware used:
ASKED: February 8, 2008  3:33 PM
UPDATED: February 8, 2008  7:45 PM

Answer Wiki:
You need to clean your data. The data type which you are using on Oracle probably doesn't reconise the year 101 as a valid year. You'll need to get your data into an ANSI standard date format before Oracle (or any RDBMS for that matter) will be able to process it correctly.
Last Wiki Answer Submitted:  February 8, 2008  7:45 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _