[python-win32] Running SQL queries on excel sheets
Rickey, Kyle W
Kyle.Rickey at bakerhughes.com
Fri Mar 14 21:17:57 CET 2008
That's also not a bad idea, most of the time, the data I'm interested in
will be at least 1-2 weeks old. That would also be better than exporting
everything to SQL every time a user saves the document.
Thanks for the info about Turbo Gears, etc. I'll have to check those
From: python-win32-bounces at python.org
[mailto:python-win32-bounces at python.org] On Behalf Of Kevin Horn
Sent: Friday, March 14, 2008 2:39 PM
To: python-win32 at python.org
Subject: Re: [python-win32] Running SQL queries on excel sheets
On Fri, Mar 14, 2008 at 1:01 PM, Tim Roberts <timr at probo.com> wrote:
Rickey, Kyle W wrote:
> In a perfect world I would get all the data into our SQL
> write a front end for everyone that needs to access/modify the
> that's a ways down the road. I've still got to convince people
> company that excel is NOT a good way to store database info!
I would probably run a batch process eevry night to load the Excel
sheets into the SQL server, and run my queries against that. Your data
would be slightly out of date (not including "today"'s data) but I would
think it's an acceptable compromise (your situation may vary).
Once you get around to writing a DB frontend, newer web framework
projects like TurboGears, when combined with a DataGrid, or using
DBSprockets/DBMechanic, can make this a lot easier than it would have
been even a couple of years ago.
I'm sure Django has similar ways of simplifying this, but I haven't used
In the meantime, to cheer yourself up, consider the following:
It could be worse, they could be using MS Access!
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the python-win32