By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,908 Members | 1,892 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,908 IT Pros & Developers. It's quick & easy.

python reading excel thru ADO ?

P: n/a
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
Jul 18 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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"
Jul 18 '05 #2

P: n/a
On Mon, 14 Mar 2005 16:20:17 GMT, Chris Curvey <cc*****@earthlink.net> wrote:
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/

--
Cheers,
Simon B,
si***@brunningonline.net,
http://www.brunningonline.net/simon/blog/
Jul 18 '05 #3

P: n/a
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

Jul 18 '05 #4

P: n/a
>>>>> "tc" == tc <t.******@buonviciniag.ch> writes:

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
Jul 18 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.