| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering parameter criteria MS Query
Hope someone can help. Im trying to extract data from a SQL Server 2005 into
Excel, using a parameter criteria in MS Query. If I use criteria in a field with an integer data type it works fine. If I use a field with an NVARCHAR data type (which is the one I want) I get a Syntax Error message. There seems to be no way of entering criteria into this type of field which MS Query will accept. If I enter james it defaults to Njames, which works as syntax criteria in SQL Server Management Studio 2005, but not in MS Query. What am I doing wrong?! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
| How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
| Parameter/Criteria option not available for External Data Query | Excel Discussion (Misc queries) | |||
| How to write parameter query with "or is null" criteria | New Users to Excel | |||
| Criteria using "Or" and parameter query | Excel Discussion (Misc queries) | |||
Threaded Mode
