Import from Acess problems with SQL language

T

toby131

I have a query in access where I use SQL code to calculate a field. In the
SQL code I have a series of if statments that use * to represent any
character and # to represent any number. The query outputs the correct
results in Access. When I import this to excel, it does not correctly
interpret the * or #, so outputs my "then" from the if statement. Is there
somewhere in Excel 2003 that I can change the language it is using to
recognize the * & #?

For clarification, here is an example:

IIf([Type] like "8##*, "800", "x")

Results in Access
Type Result
825XY 800
650ZX x
875YX 800

Results I am getting in Excel
Type Result
825XY x
650ZX x
875YX x

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top