Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
'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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fetching multiple fields data | Excel Discussion (Misc queries) | |||
Incremental number for a fetching data | Excel Worksheet Functions | |||
Fetching data from another worksheet | New Users to Excel | |||
Fetching data from other sheets | Excel Discussion (Misc queries) | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) |