View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gustaf Gustaf is offline
external usenet poster
 
Posts: 69
Default LIKE won't work in VBA/ADO app

I'm calling an Access DB from Excel, and on some queries, I want to use LIKE. But I always get an empty recordset, even if there are matching records! The query looks like this:

SELECT * FROM Person WHERE [Name] LIKE 'Gu*' ORDER BY [Name]

Is there anything wrong with this query? If I write out the full name (LIKE 'Gustaf') I get a matching record.

Gustaf