python reading excel thru ADO ?

Chris Curvey ccurvey at earthlink.net
Mon Mar 14 13:06:16 EST 2005


Chris Curvey wrote:
> Windows-specific question for you all...
> 
> I've been reading http://www.mayukhbose.com/python/ado/ad-connection.php 
> , which seems to infer that I can read an Excel file using the ADO 
> interface with Python on Windows.  Unfortunately, the usual problem with 
> ADO -- connection strings -- is raising it's ugly head.
> 
> Has anyone made this work, and would you share the connection string 
> that you used?
> 
> Thanks!
> 
> -Chris

Chalk up a brain fart for me!  I was doing "connection.open()", not 
"connection.Open()", and the error message made me think that there was 
a problem with the connection string.

Thanks all!

-Chris

P.S.  The proper URL above ends with "ado-connection.php"



More information about the Python-list mailing list