I am in the process of moving my data from Excel to Azure SQL. Fairly new to SQL. I am using the import wizard and getting the error message:The value violated the integrity constraints for the column.
the error is to do with this column. Does anyone know how to set the Nullable value
What about to click on checkbox and switch "nullable" as "yes" for "Invoice paid" column?
Or reformulate your question
It doesn't allow me to check the box
Are wizard will transfer data to new table or existing?
Got it sorted thanks. I had copied the App from SharePoint source to SQl database source a few days ago to test. I am now copying over the live data. I was trying to import the table as a new table which was giving me the error so instead I imported and updated the existing table that was created by the app and that worked
I think you could do the process through AppSheet if you have both, the old (but updated) and new (outdated) tables on your app and a Loop action that adds the row if it's not already, if there are not so many rows.
Since you are on an Enterprice account, you could also do it by using AppSheet API
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |