'Not Like' Error when fetching data from Access
I have an Excel workbook that fetches data from a MS Access database. I have
the data connections set-up by selecting the database and indicating which
Access query to run. In some cases, the data returned to Excel does not
match the data returned if I were to run the query in Access. If I use MS
Query to fetch the data, the data returns correctly.
For example, using the database connection, the following value would be
returned:
Part Cost
AV-100 $503.10
MS Query would return:
Part Cost
AV-100 $410.50
The key seems to be a 'Not Like' condition in the queries. I have compared
the query outputs via Excel and via Access and they match until I use a Not
Like condition. Is there something I can do to make sure that this parameter
is passed when Excel fetches the data?
The reason I do not use MS Query for everything is that it is that the query
process is very slow.
Let me know if more information is needed!
Thanks in advance.
PJ
|