How do I change data in a database using excel?

0
I have an application with some data and now I see a discrepancy in one data which I want to correct, how can I achieve this using excel import?  I tried creating an excel import template with Id(AutoNumber) and Name(String) which is to be changed for one instance in my database and tried importing an excel file with the required data that is id and changed name but when ever  I tried importing the data I am getting an error that Autonumber field cannot be mapped manually. How should I proceed further.     This is how my table is and I want to change the name,
asked
2 answers
0

If it's just a single record, you may find it easier to just create an edit page for this entity in your Mendix application and change the value directly that way. If you do this, consider making it something only an Administrator role can do as you probably don't want anyone else modifying this data.

answered
0

Since I wanted to change data from existing data I imported the excel with Synchronize objects and the data got changed .

answered