Message from discussion
Data entry automation using python
Received: by 10.210.18.18 with SMTP id 18mr1262201ebr.8.1246520884205;
Thu, 02 Jul 2009 00:48:04 -0700 (PDT)
Return-Path: <ch...@simplistix.co.uk>
Received: from server1.simplistix.co.uk (server1.simplistix.co.uk [89.151.125.140])
by gmr-mx.google.com with ESMTP id 14si502290ewy.1.2009.07.02.00.48.04;
Thu, 02 Jul 2009 00:48:04 -0700 (PDT)
Received-SPF: pass (google.com: best guess record for domain of ch...@simplistix.co.uk designates 89.151.125.140 as permitted sender) client-ip=89.151.125.140;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: best guess record for domain of ch...@simplistix.co.uk designates 89.151.125.140 as permitted sender) smtp.mail=ch...@simplistix.co.uk
Received: from Ableton.local (unknown [82.110.132.157])
by server1.simplistix.co.uk (Postfix) with ESMTPA id ACBFA4F808A
for <python-excel@googlegroups.com>; Thu, 2 Jul 2009 08:48:03 +0100 (BST)
Message-ID: <4A4C6641.5050600@simplistix.co.uk>
Date: Thu, 02 Jul 2009 08:48:17 +0100
From: Chris Withers <ch...@simplistix.co.uk>
User-Agent: Thunderbird 2.0.0.22 (Macintosh/20090605)
MIME-Version: 1.0
To: python-excel@googlegroups.com
Subject: Re: [pyxl] Re: Data entry automation using python
References: <b6c70528-5c33-478f-aae8-ceef02a00945@g19g2000yql.googlegroups.com> <22166b750907020042hcd18a5bv9512d30ac4dc9d74@mail.gmail.com>
In-Reply-To: <22166b750907020042hcd18a5bv9512d30ac4dc9d74@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Tony Theodore wrote:
> Do you really need to automate entry into the forms, or just get the
> data into the database? Having played a little with win32com
> (https://sourceforge.net/projects/pywin32/), I'd say it's definitely
> possible. Having worked with Access forms, I would try writing
> directly to the underlying tables first.
Indeed, xlrd to read the data from the excel file and something like
mxODBC to put it into Access would be the way I'd go...
Chris
|
