Troubleshooting
Problem
I'm using ODBC to import an Excel spreadsheet into SPSS for Windows. At the 2nd step of the Database Wizard, when I grab the worksheet I want to bring over from the 'Available Tables' box and start to move it to the 'Retrieve fields in this order' box, I get an Error Message pop-up that says "Table 'xxxxxx' has no columns and will not be shown." I know that's not true, and I can open the file in SPSS using File->Open->Data and selecting the .xls file directly. What's wrong?
[{"Product":{"code":"SSLVMB","label":"IBM SPSS Statistics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Not Applicable","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Historical Number
20995
Was this topic helpful?
Document Information
Modified date:
16 April 2020
UID
swg21476928