I want to use excel edit notes document’s data,and after user finish edit,update the excel data to notes document. How could I achieve this function? pls help. Thanks!
Subject: How to exchange data between notes and excel
You can do this using Notes FX if you are using the Notes Client.
Search for FX in the help.
Charlie
Subject: How to exchange data between notes and excel
You may consider using the NotesSQL driver (available for free on this site). Then you can access the Notes Server using an ODBC Source.
However, this may only be useful if your number of Excel-to-Notes users is limited, because you have to setup the driver and to configure the ODBC source on each client.
Another way could be accessing the Notes Server using the Notes client COM objects. Here no driver and ODBC source setup needed, but heavy COM programming in Excel required.
Subject: How to exchange data between notes and excel
You could do this in notes using OLE, but the export and import would be triggered from notes. That means that the update of the notes document wouldn’t happen immediately, but once the user has gone back to the notes document and clicked ‘update from Excel’ action or something. It depends on how you want the application to work.
Search for ‘excel and ole and import’ or excel and ole and export’ for tips (the R5 forum has more info on this).
Dan