Thanks John, I'll check that out.
-Kyle Rickey
-Original Message-
From: John Machin [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 16, 2008 4:40 AM
To: Rickey, Kyle W
Cc: python-win32@python.org
Subject: Re: [python-win32] Running SQL queries on excel sheets
Rickey, Kyle W wrote:
Rickey, Kyle W wrote:
> Tim, thanks for your response. I've got 7 excel files that need reading
> containing a total of ~6100 rows. I agree, about this code making me
> sick :)
That's not exactly "absolutely tons of data" :-)
One problem with the ODBC approach to reading spreadsheets (at least
w
-Kyle Rickey
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Horn
Sent: Friday, March 14, 2008 2:39 PM
To: python-win32@python.org
Subject: Re: [python-win32] Running SQL queries on excel sheets
On Fri, Mar 14, 2008 at 1:01 PM, Tim
On Fri, Mar 14, 2008 at 1:01 PM, Tim Roberts <[EMAIL PROTECTED]> wrote:
> Rickey, Kyle W wrote:
> > In a perfect world I would get all the data into our SQL server and
> > write a front end for everyone that needs to access/modify the data, but
> > that's a ways down the road. I've still got to co
Rickey, Kyle W wrote:
> In a perfect world I would get all the data into our SQL server and
> write a front end for everyone that needs to access/modify the data, but
> that's a ways down the road. I've still got to convince people in the
> company that excel is NOT a good way to store database inf
c: python-win32@python.org
Subject: Re: [python-win32] Running SQL queries on excel sheets
Rickey, Kyle W wrote:
> Tim, thanks for your response. I've got 7 excel files that need
reading
> containing a total of ~6100 rows. I agree, about this code making me
> sick :)
>
> In a per
Rickey, Kyle W wrote:
> Tim, thanks for your response. I've got 7 excel files that need reading
> containing a total of ~6100 rows. I agree, about this code making me
> sick :)
>
> In a perfect world I would get all the data into our SQL server and
> write a front end for everyone that needs to ac
2008 9:56 AM
Cc: python-win32@python.org
Subject: Re: [python-win32] Running SQL queries on excel sheets
Rickey, Kyle W wrote:
> I've got several excel sheets I would like to run SQL queries on and
> I've worked out a couple of ways, but I'm not sure what the best way
> woul
Rickey, Kyle W wrote:
> I've got several excel sheets I would like to run SQL queries on and
> I've worked out a couple of ways, but I'm not sure what the best way
> would be. I've also got a problem where I can't connect to the excel
> file if someone is currently editing it. Given the following t
I've got several excel sheets I would like to run SQL queries on and
I've worked out a couple of ways, but I'm not sure what the best way
would be. I've also got a problem where I can't connect to the excel
file if someone is currently editing it. Given the following to code
samples, which one is b
10 matches
Mail list logo
