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.