| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 MS Query prompt yields Syntax error
When getting external data from a MS Access database I use a query that
prompts for the criteria [criteria]. Excel 2007 Beta 2 yields a syntax error when the data is entered in the prompt. In MS query edit mode, when the same data is placed in the criteria column directly in place of the prompt, the query executes correctly. The prompt worked correctly under Excel 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Query import from Excel - Syntax Error | Excel Discussion (Misc queries) | |||
| Error message when using Excel to open text file | Excel Discussion (Misc queries) | |||
| excel compile error. Only some computers? | Excel Discussion (Misc queries) | |||
| excel compile error. Only some computers? | Excel Discussion (Misc queries) | |||
| Renaming Access Query used by Excel | Excel Discussion (Misc queries) | |||
Linear Mode
