Store SpecialCharacters eg: (<>+;,)in database and use in query

[msadiqrajani]

Hi,
I had large excel files which I imported to Excel database.
The data contains special characters with stings..Eg: sometexr<var> + othertext<othervar>.

The data is imported in access tables successfully, But I am unable to use these as a criteria in query.

Query eg:

update datatable set value = 5
where
variable = 'sometexr<var>+othertext<othervar>'

I got error message says Syntax error(missing operator) in query expression 'sometexr<var>+othertext<othervar>'

Please help me how could I use these characters in query.

Thanks

 

[John Big Booty]

Check out the Eval() function.

The attached sample demonstrates how it works

 

[vbaInet]

Eval() doesn't work well in queries. Give us real examples of what the text actually is.

 

[Pat Hartman]

You can't change the structure of a query with parameters. The only thing parameters can do is provide a value to check against at runtime. Changing relational operators or the columns involved in a condition could completely change the execution plan.

If your criter is dynamic, you will need to construct SQL strings in VBA and run them that way.