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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking to selected fields in an external table 4
Linking a Table in Access with 365 Data Fields 3
Linked Table 3
link to oracle table list shown is incomplete 1
Embed Username & Password in Oracle External Linked Table 1
Oracle linked tables 3
oracle sql plus - modified table column - not showing in Access 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top