SQL.Request method

can somebody tell me what's the equivalent of SQL.Request() method in excel 2007? It seems the add-in doesn't come b开发者_Go百科uilt-in as part of excel versions after 2002. What's the solution for this ??

According to Microsoft, "It is recommended that you use the objects, methods, and properties in the Microsoft ActiveX Data Objects (ADO) library instead of SQLRequest and the other ODBC functions in the Xlodbc.xla add-in."

You might find some helpful information here:

How to transfer data from an ADO Recordset to Excel with automation

Using ADO with Excel Data Sources