Setting up the spreadsheet
UNICOM Intelligence Developer Documentation Library includes a sample spreadsheet you can modify. It describes how the spreadsheet is set up and which columns you must create. The file is called UsersAndRoles.xlsx, and it is usually in this folder:
[INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\DDL\ Administration Tools
The Excel spreadsheet can have any or all of the following worksheets:
If a worksheet does not exist, that part of the import process does not run.
The import process decides the length required for each column based on the first few rows of the spreadsheet. If a column contains text values longer than 255 characters, do one of the following:
▪Make sure that the longest values are in the first row to ensure that the import allocates enough space for that column.
▪Set the TypeGuessRows registry value to 0 under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines\Excel\. This forces the Excel Driver to check the first 16384 rows for the data type and length.
See
See also