Data entry automation using python - python-excel

Message from discussion Data entry automation using python

Tony Theodore

More options Jul 2, 5:42 pm

From: Tony Theodore <tony.theod...@gmail.com>

Date: Thu, 2 Jul 2009 17:42:31 +1000

Local: Thurs, Jul 2 2009 5:42 pm

Subject: Re: [pyxl] Data entry automation using python

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

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

Reply to author Forward