473,327 Members | 1,952 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

python reading excel thru ADO ?

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
4 1869
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
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
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
>>>>> "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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Andrew Dalke | last post by:
Is there an author index for the new version of the Python cookbook? As a contributor I got my comp version delivered today and my ego wanted some gratification. I couldn't find my entries. ...
9
by: | last post by:
I have a web page written in asp.net that has multiple datagrids on it that would need to be exported to Excel. Each of the datagrids would be a subset of what the datagrid above it was. Thus...
8
by: fahadqureshi | last post by:
Hello, I posted here before asking a question about reading excel. Now that the reading problem is solved i am having trouble on how to write to an excel file. This was my code to read the excel...
1
by: ndedhia1 | last post by:
I was reading in a log file like this that had no milliseconds: QuoteBlockTiming exceeded 1 ms: 1 --- Thu Dec 10 02:01:40 CST 2009 170.137.15.155 Class key = 601650761 block size QuoteBlockTiming...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.