Access to Oracle Datatypes?

     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 Received on Wed Apr 28 2004 - 14:17:16 CDT