exceltoTable_conversion error 99999

774
2
11-28-2016 01:06 AM
JonGarrido
New Contributor III

Hello,

It's curious... When I run a a python script with the excelToTable_conversion it throws me an 99999 error. Even using a very simple excel with just 2 text columns.  But when I use the tool from the arctoolbox taking the same source an destination it fails with this error...

ArcGis version 10.3

Thanks in advance!!!

0 Kudos
2 Replies
JayantaPoddar
MVP Esteemed Contributor

Did you install 2007 Office System Driver: Data Connectivity Components? If not, then close all ArcGIS Desktop applications, install the above component and try again.

Also take care of the file name and path name of the excel sheet (No space or special characters in path/file name except underscore).

Could you attach a screenshot of the tool with the all parameters filled or maybe  your code.



Think Location
0 Kudos
JonGarrido
New Contributor III

Thanks for your comments. I've found out the problem.. the target folder I was typing down was a SDE.tabletarget , and the correct destinatino should be DBO.tabletarget....  That was the reason of the exception.. 

KR

Jon

0 Kudos