Getting data to Access from Brio and Toad

[Kc-Mass]

Brio and Toad are, as I understand them, front end query tools for server
level data. An application I am working on requires that I move data from
these tools to MS Access for reporting. The existing process involves
copying the data to the clipboard and then pasting to Excel and then
importing to Access (ouch!).

Does anyone know if I can either fetch the data directly from the query
tools to Access (perhaps ODBC) or failing that, directly from the clipboard
to access?

All help appreciated.

Kevin C

[Tim Marshall]

Kc-Mass wrote:

Does anyone know if I can either fetch the data directly from the query
tools to Access (perhaps ODBC) or failing that, directly from the clipboard
to access?

AFAIK, TOAD is an Oracle query and ddl tool, though I don't have
experience with it. I think it's supposed to be a souped up version of
SQL Plus.

Use ODBC to access Oracle (or whatever c/s dbms it is) tables and views.

Brio is a report writer, which has a similar function to Crystal as far
as I know - I know of it from a couple of colleagues who use the same
CMMS app I do, but like TOAD, I have no experience with it.

Better to use the database data directly via ODBC, IMO.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me