Go to Google Groups Home    python-excel
Re: [pyxl] Re: Data entry automation using python

Chris Withers <ch...@simplistix.co.uk>

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