'Not Like' Error when fetching data from Access

P

PJFry

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
 

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

Similar Threads

Access Query to import from Sharepoint 0
Adding data to MS Access from csv file 0
Some mail merge fields not pulling into document 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Excel 2010 (64 bit) External Data connection with Access 0
No Results returned from Access query 3
Using "like" query from and external link to Access 1
Using "like" from an external link 1

Top