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:
Software/Hardware used:
ASKED:
February 8, 2008 3:33 PM
UPDATED:
February 8, 2008 7:45 PM
RELATED QUESTIONS
- Getting "EXP-00091: Exporting questionable statistics." error on Oracle export
- oracle forms 6i, export, import
- Oracle 9i export unsuccessful since patch update.
- How can I export from Notes to MS Access and have links function within Access taking you back to a Notes data page?
- Temporary recordset in MS Access VBA
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
