[python-win32] Updating table in Access

Norlin Abd Rahim lin at centurysoftware.com.my
Mon Apr 28 14:05:01 EDT 2003


Hi,
I have a script :

import win32com.client

a = win32com.client.Dispatch("access.application")

a.DoCmd.TransferSpreadsheet(0,0,"ut_message","new.xls",True)
a.DoCmd.TransferSpreadsheet(0,0,"ts_description","desc.xls",True)

i've tried few times that if i open the database that i want to update , 
it works. But now, when i tried it again its not updating. Is this 
script correct and while running it the database that i want to update 
must be opened?

TIA




More information about the Python-win32 mailing list