Does SQL.REQUEST really work?

[mrl]

I'm looking for a way to dynamically create an SQL database query in
visual basic on the mac under OSX. From everything I've read, this
feature doesn't exist. However, I found SQL.REQUEST under Excel X help.
It claims to to be able to send a request to either dBASE, SQL Server,
or Oracle data sources. Is this for real, or is it simply a help entry
leftover from the Windows version, that doesn't work on the mac?

Btw, if desperate, could I simply install Virtual PC, and run Windows
Excel, and then be able to either use SQL.REQUEST or QUERYTABLES within
my Excel VBA? Thanks!

Mark

 

[JE McGimpsey]

I'm looking for a way to dynamically create an SQL database query in
visual basic on the mac under OSX. From everything I've read, this
feature doesn't exist. However, I found SQL.REQUEST under Excel X help.
It claims to to be able to send a request to either dBASE, SQL Server,
or Oracle data sources. Is this for real, or is it simply a help entry
leftover from the Windows version, that doesn't work on the mac?

Btw, if desperate, could I simply install Virtual PC, and run Windows
Excel, and then be able to either use SQL.REQUEST or QUERYTABLES within
my Excel VBA? Thanks!

From XL04 Help ("About the SQL.REQUEST worksheet function"):

The SQL.REQUEST worksheet function is not compatible with Microsoft
Excel X for Mac and Microsoft Excel 2004 for Mac. Use Microsoft Query to
connect to an external data source and run a query from a worksheet.