Message from discussion
Data entry automation using python
Received: by 10.115.90.11 with SMTP id s11mr530576wal.20.1246534861722;
Thu, 02 Jul 2009 04:41:01 -0700 (PDT)
Return-Path: <sjmac...@lexicon.net>
Received: from poplet1.per.eftel.com (poplet1.per.eftel.com [203.24.100.46])
by gmr-mx.google.com with ESMTP id k32si809920wah.6.2009.07.02.04.41.00;
Thu, 02 Jul 2009 04:41:00 -0700 (PDT)
Received-SPF: neutral (google.com: 203.24.100.46 is neither permitted nor denied by best guess record for domain of sjmac...@lexicon.net) client-ip=203.24.100.46;
Authentication-Results: gmr-mx.google.com; spf=neutral (google.com: 203.24.100.46 is neither permitted nor denied by best guess record for domain of sjmac...@lexicon.net) smtp.mail=sjmac...@lexicon.net
Received: from [192.168.1.2] (202.76.163.18.dynamic.rev.eftel.com [202.76.163.18])
by poplet1.per.eftel.com (Postfix) with ESMTP id 23D95441A6
for <python-excel@googlegroups.com>; Thu, 2 Jul 2009 19:40:58 +0800 (WST)
Message-ID: <4A4C9CC9.40300@lexicon.net>
Date: Thu, 02 Jul 2009 21:40:57 +1000
From: John Machin <sjmac...@lexicon.net>
User-Agent: Thunderbird 2.0.0.22 (Windows/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> <4A4C6641.5050600@simplistix.co.uk>
In-Reply-To: <4A4C6641.5050600@simplistix.co.uk>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
On 2/07/2009 5:48 PM, Chris Withers wrote:
> 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...
pyODBC is another solid ODBC library.
|
