I can't read excel files with data access search cursor since I upgrade to Python 64 background processing. I have the office system drivers so that's not the problem. Also, I was able to read excels files fine before I upgraded. I even tried the same script in a computer running on Python 32 and then in mine with Python 64,.It worked in Python 32, but failed in Python 64 so I'm pretty sure the problem is with Python 64.
Have anyone run into this or knows how to fix it?
Here a simple example of what I can't do anymore:
import arcpy spreadsheet = r'spreadsheet.xlsx\Sheet1$' with arcpy.da.SearchCursor(spreadsheet, 'name') as cursor: for row in cursor: print row