Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS database query: Statement CASE WHEN THEN ELSE END
Hi all,
I want to create in Excel (via data/import new external data/new database query) a query from MS Access database using statement case. MS query still complains. I tried something like this example (using Northwind sample database): SELECT employees.EmployeeID, employees.LastName, case when employees.country = 'USA' then 1 else 0 end FROM Nwind.employees employees What is wrong? The Microsoft query still complains that it didn't expect 'employees' after the select column list. I have also tried several variant like "... code = case ...." or .... end as 'code'..." but no improvement. thank you very much for any help. riso |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 case sensitive problems with New Database Query | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Excel query of Postgress database - schema case problem.. | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) |