<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I would like to add a button to a Lotus Notes application that deletes all records and then imports new records from preferably an xls or otherwise a wk4 file.<br />
<br />
Does someone have a code snippet showing how I can do this?<br />
<br />
Regards, MB<br />
<br />
The above is a simplification of the following procedure:<br />
1. Every morning an Excel macro is copying the sheet &quot;current&quot; to &quot;previous&quot;.<br />
2. Then current is refreshed by pulling data from an oracle DB<br />
3. The sheet difference is updated<br />
4. An wk4 export file is created<br />
5. In notes manually all records are deleted<br />
6. The wk4 export file is imported<br />
<br />
The above could most likely also be solved completely in Lotus Notes without Excel, but I am not sure how complicated this task is in Lotus Notes and therefore the question to just delete all records and connect to Excel. 
</div>
</div>


Hi Experts,
I would like to add a button to a Lotus Notes application that deletes all records and then imports new records from preferably an xls or otherwise a wk4 file.

Does someone have a code snippet showing how I can do this?

Regards, MB

The above is a simplification of the following procedure:
1. Every morning an Excel macro is copying the sheet "current" to "previous".
2. Then current is refreshed by pulling data from an oracle DB
3. The sheet difference is updated
4. An wk4 export file is created
5. In notes manually all records are deleted
6. The wk4 export file is imported

The above could most likely also be solved completely in Lotus Notes without Excel, but I am not sure how complicated this task is in Lotus Notes and therefore the question to just delete all records and connect to Excel. 

Import data in a view in Lotus Notes

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.