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.