table vs system table in excel import

Posted by Maguin, Eugene on Aug 04, 2015; 5:16pm
URL: http://spssx-discussion.165.s1.nabble.com/table-vs-system-table-in-excel-import-tp5730367.html

I’ve noticed that when reading an excel (.xlsx) file through the Open Database menu, the ‘Table’ box is always checked but in order to see the fields in the sheet, the ‘System Table’ box must be checked. I don’t recall that that was true for .xls files. I’m curious (no complaints) as to why the difference and (ok, small complaint) why, if the system table box MUST always be checked, this is not done by default. Is there a situation when the system table box would not be checked?

 

Gene Maguin

===================== 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