Is to use the excel when database, query part of existence in the datatable, modified, then update to excel, report the error, it is said that because there is no primary key
Excel and don't know how to set the primary key

CodePudding user response:

Add a list of the primary key, 1, 2, 3... Automatic pull down

CodePudding user response:

reference 1st floor LvBao_117 response:

add a primary key, 1, 2, 3... Automatic pull down

I have a column set the id in excel, but update or hint that mistake

CodePudding user response:

refer to the second floor therightofsky response:

Quote: refer to 1st floor LvBao_117 response:

add a primary key, 1, 2, 3... Automatic pull down

I have a column set the id in excel, but when updates or hint that the wrong

Id is not set the primary key yet

CodePudding user response:

That I need is how will the excel that set a list of the primary key?
I set the query to the datatable id primary key, but still an error?
Is it because the primary key of the datatable unable to excel in the table corresponding to the original

CodePudding user response:

Use excel why not Access? Actually all is not recommended

CodePudding user response:

reference 5 building independent observers reply:

use excel why not Access? Actually don't recommend

Because to deal with the original data and the final output data, is excel, so just going to ~
Made the access to import and export, back and forth a bit slower, thinking if only use excel can hurry up

CodePudding user response:

https://blog.csdn.net/yinjianjing/article/details/6278279