SQL failing in VBA but not on the DB

[Chrissirhc]

I have a query that works in DBArtisan(DB connection and management software) but not in my VBA code.

In my VBA code I get the error:

Invalid column name "E".

My sql is a bit like this

select * from table where myLookup in ('A','B','C','D', 'E')

If I change it to select * from table where myLookup in ('A','E') it works fine...

I am using ADODB.

Any ideas?

Thanks,

Chris

 

[SkipVought]

Hi,

How is your table structured?

Skip,

_[red][/red]

 

[Chrissirhc]

My post is wrong. Please ignore and apologies. I should be using ' instead of " Thanks.