Thank you, I'm a little lost about how to figure out what goes on the CONNECT statement (all the help says is to generate it through the wizard). Below is the example of my code for pulling the table after it is dumped into Access.
GET DATA /TYPE=ODBC /CONNECT=
'DSN=MS Access Database;DBQ=C:\Documents and'+
' Settings\andrew.wheeler\Desktop\Data_Dumps\test_run\ODBC.mdb;DriverId=25;'
'FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;'
/SQL = 'SELECT DEPTNO, `YEAR`, INCDNO, SEQNO, STATEUCR, OFFENSESEVR, '+
' DISPDATE, OFFENSEDISPDATE, MOTIVE, STATEDISP, '
'ATEMPTCOMMIT, THEFTCOMP, DRUGRELATED, ALCOHOLRELATED, STATEUCRNO, '+
' SPECIALMO, CLEAREDTYPE, CLEAREDDATE, CLEAREDBY,'
' ARRESTEDNO, CRIMINALACTV1, CRIMINALACTV2, CRIMINALACTV3, LARCENYTYPE'+
', ARSON, COERSION, DOMESTICV, HATECRIME, '
'DOCUMENT, WEAPONS, UNOCC, LOCALSTATE, CLASSTYPE, REVIEWDATE, '+
' LOCTYPE1, LOCTYPE2, VEHENTRYMETHOD, USEOFFORCE, '
'USEOFFORCEFILED, CHILDSTATUS, OFFICERACTION, PRIORCOURTORD, HOWENTRY, '+
' HOWEXIT, FORCEDENTRY, NOFORCE, '
'ATTEMPTFORCE, NOPREMENT, OCCUPANCY, RACIAL, ETHNIC, RELIGIOUS, '+
' SEXUAL, TBA, CHKA, CHKB, CHKC, TBB, NOA, '
'CHKD, DTA, TBC, CHKE, ARSVAL, WEAPUSE1, WEAPUSE2, WEAPUSE3, '+
' HOWENTRY2, HOWEXIT2, SECURITY1, SECURITY2, '
'TOOLSUSED1, TOOLSUSED2, EVDOBTAINED, NIBRSRPT, GANGACT, GANGTYPE1, '+
' GANGNAME1, GANGTYPE2, GANGNAME2, HOMEINV, '
'CAMPUS, REFERRAL1, REFERRAL2, REFERRAL3, REFERRAL4, REFERRAL5, '+
' REFERRAL6, TARGET, NOUSE1, NOUSE2, NOUSE3, '
'NOUSE4, NOUSE5, NOUSE6, NOUSE7, NOUSE8, NOUSE9, NOUSE10, USER1, '+
' USER2, USER3, USER4, USER5, USER6, USER7, '
'USER8, USER9, USER10, UNSTRING1, UNSTRING2, UNSTRING3, UNSTRING4, '+
' UNSTRING5, COMMENT FROM OFFENSE'
/ASSUMEDSTRWIDTH=255
.
CACHE. //May be removed but insures data integrity.
DATASET NAME offense WINDOW=FRONT.
I have alot of questions about what goes into that connect statement, but lets just start with a few. What do I put down for "DBQ"? The file is not all rolled up into one like an access database, but is a series of .TPS tables in one directory. Do I put the directory and use a from statement in SQL, or point to that exact table file? How do I figure out the DriverID? Or am I completely off base and I need to read up on how to make SQL queries?
In my few attempts I have been given a warning ">Warning. Command name: GET DATA
>[TopSpeed Corp.][TopSpeed ODBC Driver]Driver not capable". Is this significant in that I won't be able to query the data correctly within SPSS, or could it be simply the product of a bad get statement?
Thanks for all the help again, Andy
Locked
