How to get result (1 Viewer)

[vsap]

Hello guys,
I Have a table call Hq_Cases in oracle database,I created same table in access 2000,and I created a SELECT QUERy in access ,now when I run this query it shows me empty table,so I want to know how I can bring values from oracle into my access database.
Any suggestion is appreciable.

Thanks
vsap

 

[FoFa]

Have you either linked the Oracle table or creaed a Passthrough query to the Oracle table?

 

[vsap]

Thanks,no I have not done any of them,how to achieve that can u please tell me.

Thanks
vsap

 

[FoFa]

best to setup a DSN to point to your instance of oracle. Then in TABLE view select NEW, LINKED TABLE, ODBC and follow the directions.