Linking Access to selected fields in a large external table

  • Thread starter Thread starter phillbee
  • Start date Start date
P

phillbee

I want to make an ODBC link from Access 2003 to a large table in an Oracle
database. Unfortunately this table has approximately 300 fields and only the
first 255 are shown in the linked table. Inevitably some of the fields I want
to use are not shown! Does anyone know if there is a way for me to only link
to selected fields in the external Oracle table. In this way I can keep the
number of linked fields below the Access limit of 255. Alternatively any
other suggestions would be welcome, but please note I cannot make any
modifications to the external table which contains millions of records.
 
Do you need to be able to update the Oracle table, or simply read it? If the
latter, create a pass-through query that returns only the specific fields.
 
Back
Top