I am wondering about a cross connection query using Excel and Oracle.
I am getting it to work just fine.
We have need to share the tsm file, or reopen many times and rerun as data changes.
It appears that that is not allowed when Excel is one of the data sources, as when I open it, and try to execute I receive the following:
microsoft odbc excel driver cannot update. database or object is read-only
Any ideas or suggestion?