Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Syntax Error - Using Microsoft Query and ODBC link to a table
For some background - I am usingExcel 2000, SP-3A.
1) I am going into DATA/GET EXTERNAL DATA/NEW DATABASE QUERY. 2) Selecting my ODBC source and connecting to the source with no issues. 3) Selecting a SINGLE table from the ODBC soucred database and then VIEWING THE DATA OR EDIT THE DATA IN MICROSOFT QUERY. 4) Selecting the fields that I want to show in my query results (dropping and dragging) 5) Choosing VIEW/CRITERIA and then dropping the DATE field in the criteria section and enter in a date of the 01/05/2005. 6) When I then go RECORDS/QUERY NOW I received an error "SYNTAX ERROR". If I use criteria for other fields (not date fields) then it works ok and I do not get any error messages. Can someone help?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Syntax Error in Excel Query for DATE field | Excel Discussion (Misc queries) | |||
Waiting for data to be returned from Microsoft Query | Excel Discussion (Misc queries) | |||
Changing Server on a Microsoft Query | Excel Discussion (Misc queries) | |||
Excel2000 ODBC query oddity | Excel Discussion (Misc queries) | |||
Winn98SE, Excel2000: ODBC query opens the source workbook | Excel Discussion (Misc queries) |