Message from discussion
Data entry automation using python
Received: by 10.143.7.5 with SMTP id k5mr306748wfi.8.1246520552473;
Thu, 02 Jul 2009 00:42:32 -0700 (PDT)
Return-Path: <tony.theod...@gmail.com>
Received: from mail-px0-f203.google.com (mail-px0-f203.google.com [209.85.216.203])
by gmr-mx.google.com with ESMTP id 23si213126pxi.5.2009.07.02.00.42.31;
Thu, 02 Jul 2009 00:42:31 -0700 (PDT)
Received-SPF: pass (google.com: domain of tony.theod...@gmail.com designates 209.85.216.203 as permitted sender) client-ip=209.85.216.203;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of tony.theod...@gmail.com designates 209.85.216.203 as permitted sender) smtp.mail=tony.theod...@gmail.com; dkim=pass (test mode) header...@gmail.com
Received: by pxi41 with SMTP id 41so6269pxi.24
for <python-excel@googlegroups.com>; Thu, 02 Jul 2009 00:42:31 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=gamma;
h=domainkey-signature:mime-version:received:in-reply-to:references
:date:message-id:subject:from:to:content-type
:content-transfer-encoding;
bh=yH3HgwoPhffAqj4Ib+lF2lJpC9IaGC3u4aslPQt5nX8=;
b=sUEeB11X6B2oBZK6wx8+Ef/occi5c7ZGSDjQGmiYWvRJrnH5b4pZ9VItoUKMgoM4hS
hn6dhCwl+PUO5p/GQj4zME/L6TTw9zO8BgdsCspB5d1zOW5q3CUv3OLJ5m+tJMTAJXmx
W69unRZwLwgULF9nwKFH/yb9Ys29eeOn77KO0=
DomainKey-Signature: a=rsa-sha1; c=nofws;
d=gmail.com; s=gamma;
h=mime-version:in-reply-to:references:date:message-id:subject:from:to
:content-type:content-transfer-encoding;
b=ACkqVqQcAC6SmS0tQoKYAwVGZOQfiZSQuhj5effKHjjhqUKuQuBPJgpn6HvCbk1Hh5
ZLIp43l3hoNvrMCIX59e/OOtSz4c2iVWUiUJ7Scf7s+sSDkKfJvwnb0YXzpx6S8UMj5W
r+PyAfAjj1sfyTZfIF8A7My2SS4SzLDT7sEs8=
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Received: by 10.143.44.17 with SMTP id w17mr1417787wfj.105.1246520551351; Thu,
02 Jul 2009 00:42:31 -0700 (PDT)
In-Reply-To: <b6c70528-5c33-478f-aae8-ceef02a00945@g19g2000yql.googlegroups.com>
References: <b6c70528-5c33-478f-aae8-ceef02a00...@g19g2000yql.googlegroups.com>
Date: Thu, 2 Jul 2009 17:42:31 +1000
Message-ID: <22166b750907020042hcd18a5bv9512d30ac4dc9...@mail.gmail.com>
Subject: Re: [pyxl] Data entry automation using python
From: Tony Theodore <tony.theod...@gmail.com>
To: python-excel@googlegroups.com
2009/7/2 Jimbo <jims2...@gmail.com>:
>
> Hi,
>
> I am trying to automate data entry into an Access form. I would like
> to develop a python script to read values from an Excel spreadsheet
> and pass them onto fill the fields in an Access form which would then
> be saved and move onto to the next record. Is this achieveable using
> python? I am a beginner and any help would be appreciated.
>
> Cheers
> Jimmy
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.
Regards,
Tony
|
