Please help to update file[求助]

hetrick · 发表于 2003-12-11 10:16

I have one master file (db1 in Access) and I want to merge the new.xls (Excel file -every day a new.xls) to master table in db1 with the following criteria: MASTER NEW ACTION Deal No. (Primary key) exist = exist maintain master record only i.e. delete new record row Deal No. (Primary key) no record new keep new record i.e. add new record row into Master Deal No. (Primary key) exist no record delete master record i.e. delete master record row Thanks a lot Hetrick

SDdyZmz5.zip (14.6 KB, 下载次数: 12)

loadhigh · 发表于 2003-12-11 19:07

你可以参阅： http://club.excelhome.net/dispbbs.asp?boardID=26&ID=27882

		自动登录	找回密码
密码			免费注册