Two Databases Combined? ODBC Read-only + Custom

[poshea]

Here is what I am trying to do.

I have a Proprietary Database that I can connect to via ODBC read-only without an issue. I would like to be able to have my own tables that I can run queries with along side the ODBC tables. so in a similar manner to "MS Access Link Tables". anyone know the best way to handle this?

Thanks

[r4zoli]

Not supported by OOo, it is long requested feature.

[poshea]

Thanks for the quick response.

I was afraid of that. did alot of digging before coming here.

What about a macro? can you connect to a DSN and populate a table say every few minutes? and maybe on OObase open?

I would really like to make this happen, even tried to see if I could use MySQL but don't see anyway to import ODBC tables in.