SQL.Request method ..

Question

Hi, can somebody tell me what's the equivalent of SQL.Request() method in excel 2007? It seems the add-in doesn't come built-in as part of excel versions after 2002. What's the solution for this ??

Answer 1

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

Answer 2

Thanks a lot for the info. Got it working with ADO.