Subcommands for TYPE=ODBC and TYPE=OLEDB (GET DATA command)
The CONNECT and SQL subcommands are both required, and SQL must be the last subcommand.
Example
GET DATA /TYPE=ODBC
/CONNECT=
'DSN=MS Access Database;DBQ=/examples/data/dm_demo.mdb;'+
'DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;'
/SQL = 'SELECT * FROM CombinedTable'.
Note: If you are running the Windows 64-bit version of IBM® SPSS® Statistics, you cannot read Excel, Access, or dBASE database sources with GET DATA /TYPE=ODBC. The 32-bit ODBC drivers for these products are not compatible. You can, however, read Excel files with GET DATA /TYPE=XLS.