HELP - showing contents of both oracle 8i and microsoft access in VB..

[Guest_imported]

Does anyone know how to show the contents of Oracle 8 and Microsoft Access in VB's DBGrid or FlexGrid? I managed to show the contents in 2 separate grids (1 grid for Oracle, 1 for Access) but how can I show the contents of both databases in 1 grid? Please help?

 

[MikeLacey]

You could build an Access view (query) that reads data from both the Access and Oracle tables - and then populate your grid from that.

You will have to define your Oracle table as an external table in Access.

Be warned though - this is not efficient, it's likely to go very slowly. Mike
"Experience is the comb that Nature gives us after we are bald."

Is that a haiku?
I never could get the hang
of writing those things.

 

[Guest_imported]

Ok, thanks for the suggestion! I'll give it a try!