|
|
python-excel |
2009/7/2 Jimbo <jims2...@gmail.com>: > Hi, > I am trying to automate data entry into an Access form. I would like > Cheers Regards, Tony
Do you really need to automate entry into the forms, or just get the
> 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.
> Jimmy
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.