I'm trying to import a spreadsheet from census.gov. I had to delete all but 8 of the columns before it would import correctly. Anything more than that and it fails with "Underlying DBMS Error."

It isn't even any specific column that causes it to fail. If there are 9 columns left, it fails. I can delete the 9th column, and then it works. Or I can delete the 7th and 8th column instead, and it works.

The columns have 3000 rows of numeric data. I'm using the ArcGIS Pro trial version right now, in case that might have some limitations. I can post the spreadhseet if necessary.

  • 1
    I'm not aware of an XLSS format. Do you perhaps mean XLS or XLSX? – PolyGeo Feb 16 at 22:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.