Login  Register

table vs system table in excel import

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

table vs system table in excel import

Maguin, Eugene
1973 posts

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