Issue when linking / importing Oracle

[Ben]

I'm having difficulty linking and importing Oracle 9
tables in Access 2002 (SP3)
When I link or import the table from Oracle 9 into Access
2002, the import / linking
process picks up the incorrect data type.

I'm not sure if the trailing table will display correctly
so here's a quick synopsis

A field on the Oracle table is a Number, but Access sets
the data type as TEXT.
I plan on appending / updating data over the linked table
so this obviously is causing a problem.

I have switched from the Oracle 920 ODBC driver and tried
the MS Oracle ODBC driver, but I get the same
erroneous results.

Any Suggestions? thank you


The linking / importing process does not pick up the field
types correctly:

Field Oracle Data Type Access
Linked / Imported Data Type
EMPLID VARCHAR2 TEXT
EMPL_RCD NUMBER TEXT <--
INCORRECT DATA TYPE
ERNCD VARCHAR2 TEXT
EFFDT DATE DATE/TIME
ADDL_SEQ NUMBER TEXT <--
INCORRECT DATA TYPE
DEPTID VARCHAR2 TEXT
JOBCODE VARCHAR2 TEXT
POSITION_NBR VARCHAR2 TEXT
ACCT_CD VARCHAR2 TEXT
GL_PAY_TYPE VARCHAR2 TEXT
ADDL_PAY_SHIFT VARCHAR2 TEXT
OTH_HRS NUMBER NUMBER
HOURLY_RT NUMBER NUMBER
OTH_PAY NUMBER NUMBER
ADDLPAY_REASON VARCHAR2 TEXT
SEPCHK NUMBER TEXT <--
INCORRECT DATA TYPE
EARNINGS_END_DT DATE DATE/TIME
GOAL_AMT NUMBER NUMBER
GOAL_BAL NUMBER NUMBER
OK_TO_PAY VARCHAR2 TEXT
DISABLE_DIR_DEP VARCHAR2 TEXT
PRORATE_ADDL_PAY VARCHAR2 TEXT
PRORATE_CUI_WEEKS VARCHAR2 TEXT
PAY_PERIOD1 VARCHAR2 TEXT
PAY_PERIOD2 VARCHAR2 TEXT
PAY_PERIOD3 VARCHAR2 TEXT
PAY_PERIOD4 VARCHAR2 TEXT
PAY_PERIOD5 VARCHAR2 TEXT
STATE VARCHAR2 TEXT
LOCALITY VARCHAR2 TEXT
TAX_PERIODS NUMBER TEXT <--
INCORRECT DATA TYPE
TAX_METHOD VARCHAR2 TEXT
ADDL_PAY_FREQUENCY VARCHAR2 TEXT
DED_TAKEN VARCHAR2 TEXT
DED_SUBSET_ID VARCHAR2 TEXT
DED_TAKEN_GENL VARCHAR2 TEXT
DED_SUBSET_GENL VARCHAR2 TEXT
PLAN_TYPE VARCHAR2 TEXT
BUSINESS_UNIT VARCHAR2 TEXT
COMP_RATECD VARCHAR2 TEXT
RECORD_SOURCE VARCHAR2 TEXT