how to create a wildcard in MSQuery
 

Hi there,

I'm using MS Query in Excel to connect to an excel file and analyse it. I
tried using the * for wildcard characters but it didn't work.

ARe wildcard characters supported.

Thanks you in advance

Suzie

how to create a wildcard in MSQuery
 

You can use the % character, e.g.

Like '%manager%'

Grd wrote:
Hi there,

I'm using MS Query in Excel to connect to an excel file and analyse it. I
tried using the * for wildcard characters but it didn't work.

ARe wildcard characters supported.

Thanks you in advance

Suzie


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html