I have an Access2002 table with one field, x, with the value 777.
It is defined as data type=Numeric, field size=long integer. Using
Access's TableExport/ODBC to Oracle9i(creating a new table), I get the
Oracle message-1401 "Inserted value too large for column". Defining the
Access table as Number with field size=Decimal solves the problem.
I actually have hundreds of these Number/LongInteger variables in
Access tables. How can I export them to Oracle? Is there an easy way
to change all field sizes to decimal? Or is there a different solution?
thanks, tom g