Fastest Way to Oracle

[BAWC01]

Hi

I have an Oracle table containing some 180 millions records,

I want to use Access (if a good idea) what is the fastest way to to connect and retrieve records.

Thanks

Phil

 

[Darrylles]

Hi,

The fastest way to do what?
You want to 'use Access' to do what?
Is this a one-off process. i.e. export the Oracle records into MS Access once, or are you thinking of doing this regularly?
Are the Oracle records 'live'? Are they updated regularly?
Do you simply need to look at the records via Access, or update them also?

Do you have access to Oracle itself or just a single table?

I think your question should be: "How can I get records from an Oracle table into MS Access?", OR "How can I link to an Oracle table through MS Access?".
Speed doesn't seem to be your problem at this time.

If I'm right, then look here:

http://www.orafaq.com/faqodbc.htm#ACCESSATTCH

and look at:

"How does one attach an Oracle table in MS-Access?"

Once linked, it's simple to get the records into an Access table.

If I'm wrong, then please add more detail to your question.

ATB

Darrylle















Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk

 

[BAWC01]

Hi Darrylle

Sorry I should have been more specific. I have created a front end to retrieve records from an Oracle Table, but there is a Java version on the application that somebody threw together whichis much faster if a lot less informative.

That is where my question comes from, is Access the best method for developing this type of front end which accesses millions of records ?

Phil