By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,405 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

Getting data to Access from Brio and Toad

P: n/a
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
Dec 9 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Dec 9 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.