Hi Vladimir,

Before I go off in the wrong direction and give you an answer to a question
that you haven't asked, can you confirm a couple of things for me/us please?

Do I understand correctly that you are trying to use VBA, ADO and/or DAO
from one Excel workbook to fire off a query and return some records from a
table (named range or worksheet) in some other Excel workbook?

Or is it some VBScript that you're looking for us to help you with in order
to return a recordset to a web page?

Grateful if you can please confirm and provide a bit more information in
regards to your purpose and that will give me/us the best chance to help you
to help yourself. Any code snippets of how far you've already got would
probably assist too.

(As an aside, personally I normally prefer ADO over DAO and regardless, the
LIKE operator is always a bit tricky because you have to use the SQL
'flavour' and syntax that the host provider/database understands.)

Cheers, Sean.

"VladimirM" wrote:


Hi all!

I cant solve very simple task.
All I need is a query "SELECT * FROM Table WHERE Field LIKE '*value*'"

But it seems Microsoft is too huge company to let me just do that like
in PHP.

Im using DAO because hope it will work more often then ADO now do :)

1) DAO worked ONLY whith syntax [TableName$] but most of examples not
using it.
2) I have working query

Sql = "SELECT * FROM [TestList$]"
Set rs = db.OpenRecordset(Sql)

3) But cant make work WHERE clause like this:

"SELECT * FROM [TestList$] WHERE A LIKE 'asdas'"

It gives me Run-Time 3061. In the internet I read about some
_parameters_ in query.
Anybody can tell me which more PARAMETERS wants from me crazy excel
programmres?

Or just wrong syntax?
Please help.


--
VladimirM
------------------------------------------------------------------------
VladimirM's Profile: http://www.excelforum.com/member.php...o&userid=24993
View this thread: http://www.excelforum.com/showthread...hreadid=385216