python reading excel thru ADO ?
ccurvey at earthlink.net
Mon Mar 14 19:06:16 CET 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?
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.
P.S. The proper URL above ends with "ado-connection.php"
More information about the Python-list