We are having some strange problems with SQL statemnts when users want
to edit a database request in MS Query.
First the user go to "Import External Data - "New Data
request" (I don't
know the exact name for this since I haven't got an English Excel at
hand), select the source and then get into the selection guide. Here the
user just select a table and exits and get into MS Query. He then add
a couple of criteria - a number "Greater Than xxx" and "Less than xxx".
He then returns the result to Excel and everything looks fine.
When he then go back and wants to edit the selection, he get and error
like "Incorrect syntax near 'Og'. Statement(s) could not be prepared".
When I then look at the SQL statement, I can see that it translates and
"And" og "og" (which is the danish word for And). Everything else is ok.
If I look at the SQL
statement before I return to Excel it looks like this :
FROM DRIFT.dbo.FinSelskab FinSelskab
WHERE (FinSelskab.FinSelskabNr>10000) AND (FinSelskab.FinSelskabNr<20000)
- which looks fine.
When I then return FROM Excel and get the error, the statement now looks
like this :
SELECT FinSelskab.FinSelskabNr, FinSelskab.FinSelskabNavn FROM
dbo.FinSelskab WHERE ((FinSelskab.FinSelskabNr>10000 Og <20000))
- and here it has translated
"And" to "og".
We are runnning Excel in Citrix and there are a number of users who has
the problem, and at least one who doesn't. We've tried it on different
Citrix servers, but it doesn't looks like it's server related, but more
related to a user setting somewhere - maybe in the users profile.
I've looked high and low for a solution, but I'm
starting to run out of