Oracle linked table with 2.4 Million records

[Newman]

I need some datas from an oracle table, but that table has 2,400,000 records.
Access can open that table, but can't read all the records.

They have datas from 1980 and over, and all I need is the «Date()-365» records.

The table is in read only and its administrator won't do anything to help me out.

Is there a way I could get this to work?

Thank you!

 

[pdx_man]

And you have tried to create a SELECT query where the criteria is something like:

>= DateAdd('y',-1,Date())

??


If it is still too large of a recordset, try creating a Pass-Through query and specify the SQL there. That will allow the Oracle server to do all of the work.

 

[Pat Hartman]

A pass-through query is the way to go. When you use Access functions in the SQL, expecially the where clause, Jet cannot always translate them to the equivalent ODBC syntax. When that happens, Jet has to bring the ENTIRE table across the network. That seems to be what is happening to you. You'll need to look up the correct syntax for a dateadd() function in Oracle.

 

[FoFa]

select * from oracletable where DateCol > (sysdate - 366)
Oracle you can add or subtract days right from a date.

 

[Newman]

Thank you all for your help!
I have some bigger problems now, so I haven't try the pass-through query yet, but I will do it soon.
I found some interesting posts about pass-through queries.
You helped me a lot. Thanks!