HI does anyone know sql to import certain database fields into spss?
It says that I am missing an operator before the frist field, can anyone help me?
To bring the whole db I was able to do, but when I started to just select a few I really needed, it started to get wierd on me
Here's what I have:
/TYPE = ODBC
/CONNECT = "DSN=MS Access Database;"
/SQL = "SELECT ZIP Code, Zip+4 Code, Census Tract Number, Census Block Number, From Latitude, From Longitude, To Latitude, To Longitude, Multiple Match Indicator FROM ".
My output editor says this when I run it:
>Warning. Command name: GET DATA
>SQLExecDirect failed :[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ZIP Code'.
>Error # 105. Command name: EXECUTE
>This command is not valid before a working file has been defined.
>This command not executed.
HELP ME PLZZZ!