python reading excel thru ADO ?

[Chris Curvey]

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

 

[Simon Brunning]

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?

Never tried it, I'm afraid.

No, strike that. I'm actually pretty glad that I've never tried it. ;-)

But in any case this might help: http://www.connectionstrings.com/

 

[Chris Curvey]

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"

 

[tc]

I always used win32com.client to access excel files and parse them,
save them as website, csv and so on.

why exactly is it that u use ado for solving this?

TC

 

[Chris Smith]

tc> I always used win32com.client to access excel files and parse
tc> them, save them as website, csv and so on.

tc> why exactly is it that u use ado for solving this?

tc> TC

The value of ADO would be to throw some Stupid Question Language at an
..xls.
One thing to keep an eye on is text-heavy fields; I've seen >255 char
strings truncated, in which chase instantiating excel.exe is all you
can do.
R,
C