(Sorry if this is a duplicate - new to posting!)
Is there a way via code to create an index on a table that you are
exporting to Microsoft Access?
We have created a large table with SPSS syntax and need it to end up in
the Access DB with an index.
Is there any way to do this via syntax?
This is the export code I am currently using
save translate /TYPE=ODBC /CONNECT=
'DSN=MS Access
Database;DBQ=K:\Folders\be\PROD_AB3632_be.mdb;DriverId=25;FIL=MS
Access;MaxBuffer'+
'Size=2048;PageTimeout=5;'
/table = 'INSYSTforAB3632' /MAP/REPLACE
.
CACHE.
Janet
Alameda County Behavioral Health Care Services
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
