Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2003 not understanding Access 2003 "like"
I have a number of Access queries linked and displayed in an Excel workbook
by way of Data, Import External Data, Import Data. Some of the criteria and select statements in the queries use the keyword "Like" (e.g. Like "*Smith" to pull up all names ending in "Smith"). These statements seem to be completely ignored by Excel so that records I should see are not appearing in the workbook. This worked fine in versions 97 (from which we've just upgraded) so is this a version 2003 bug? If so, is there a fix? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How copy Excel macros from Excel XP (or before) to Excel 2003? | Excel Worksheet Functions | |||
excel 2003 changing saved print settings | Excel Discussion (Misc queries) | |||
Excel 2003 crashes when opening | Excel Discussion (Misc queries) | |||
How do I open a Quattro Pro 7.0 file in Excel 2003 | Excel Discussion (Misc queries) | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) |