table vs system table in excel import

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

table vs system table in excel import

Maguin, Eugene

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