Passing SQL query through Excel VBA

[#BoB#]

Hi,

I am using ADO to fetch data from MS Access Database:

My Query is:

---------------------------------------------------------------

SELECT Account, Description, dDate, Bkgs, Practice FROM [Service Line 2010] WHERE Account Like '*info*'

---------------------------------------------------------------

I need the details of all the Accounts where the Account field contains "info" in anywhere of the string.

This query works fine if I try it directly in Access, but doesn't give me any data when I try to pass it through VBA (Excel)

I have tried couple of more queries, and the problem seems when I use the "*" with the Like keyword. Otherwise I am getting records.

Please suggest how do I write a query in VBA that fetches data from the database by matching "Contains" condition.


Regards,

 

[#BoB#]

I got the solution:

Just replace the * with %


Cheers,