Page 1 of 1

Two Databases Combined? ODBC Read-only + Custom

Posted: Fri Jul 23, 2010 8:47 pm
by 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

Re: Two Databases Combined? ODBC Read-only + Custom

Posted: Fri Jul 23, 2010 9:07 pm
by r4zoli
Not supported by OOo, it is long requested feature.

Re: Two Databases Combined? ODBC Read-only + Custom

Posted: Fri Jul 23, 2010 9:14 pm
by 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. :cry: