Link to selective rows in Oracle table

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
 
J

Jeff Boyce

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
Access 2007 ODBC for Oracle linked table issue 0
Linking to Oracle 2
Field Values When Linking to an Oracle Table 1
Error: Cannot add MS ODBC for Oracle 1
ODBC Connection To Oracle 5
coonnecting to Oracle Database 1
Link to Oracle Database using ODBC - Table Name Problem 1

Top