#BoB#
Active Member
- Joined
- May 20, 2008
- Messages
- 303
Hi,
I am using ADO to fetch data from MS Access Database:
My Query is:
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,
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,