Home > IT Answers > Database > Exporting MS Access data to Oracle
Help

Question

  Asked: Feb 8 2008   3:33 PM GMT
  Asked by: M1

Exporting MS Access data to Oracle


ODBC, Oracle, Access

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.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
Last Answered: Feb 8 2008  7:45 PM GMT  by Mrdenny




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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Database and Oracle.

Looking for relevant Database Whitepapers? Visit the SearchOracle.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register