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
 
Back
Top