I’m connecting excel with notes SQL , ODBC to my local file names.nsf .
In MS Query I can get the data. But when I try changing the data and refresshing, Ms query just craches.
In excel I can also get the data, but when I change some data and refresh, the data I changed just dissapears.(nothing has been changed)
This seems logical because when I have a look at the sql instructions I can see :
“SELECT Person.FullNameInput, Person.CompanyName, Person.CompNumber,…FROM Person Person”
Any idea how to be able of updating this table ?