阅读背景:

Excel VBA to:只添加从Excel中修改的记录来访问

来源:互联网 

I have an excel spreadsheet which downloads the most up-to-date record set from a database via ADODB connection. Most up-to-date records are base on the import date/time. Once the information has been loaded onto the Excel Spreadsheet, I want the analyst/end-user to update any record as they see fit. When the analyst click the submit button, I only want the modified record(s) to be APPEND into the same table in MS Access 2007 database, which sits on a share drive. The database will automatically add an import date/time for each record.I have an excel spreadsheet which downloads the




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: