Answer: Yes you can however you must be a bit careful using the refresh query option. When using the refresh query option SQL*XL assumes you will run the statements against the current database connection.

You can run one statement against database1 and then connect to database2 to run the second statement. If you record the whole session in a macro you have a command to run two commands against different databases.

You can make use of the usual database tricks to access other databases. With Oracle e.g. you can use the @ symbol to denote a particular database if you have setup the database links in Oracle: select * from emp@my1stDatabase; selelct * from emp@my2ndDatabase;

When you use SQL Server you can use the openquery function to run a query against a different database. Again here you need to setup the database link first.

Copyright (C) 1995-2007 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap