Link to selective rows in Oracle table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am able to link to an Oracle table but I don't want to pull in all 2
million records from the table, only a selection based on criteria.

I cring at asking such a basic question but is there a way when I link to an
Oracle table in Access to only pull data based on criteria (like Fiscal Year,
Account and so on)?

Thank you,
AnnP
 
One way to do this would be to create a view in Oracle that only returns
what you are looking for. The "link" to those views.

Another might be to use Pass-Through queries in Access.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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 Access and Oracle Database 2
Can't get real oracle error with Access error 3155 0
oracle fields exceed 255 3
Access 2007 ODBC for Oracle linked table issue 0
Linking to Oracle 2
Field Values When Linking to an Oracle Table 1
Linking to Oracle via ACCESS 1
Error: Cannot add MS ODBC for Oracle 1

Back
Top