In the SQL server will be confronted with default values to be inserted into Excel file, in this case how to import data and insert the correct value by default??

CodePudding user response:

Import, oneself update well,
The definition of general database table automatically inherit the excel form definition, so there will be no conflict,
If is manual definition, it will form the set to allow null columns, guide their update again

CodePudding user response:

Suggest the guide into an intermediate table (no primary key, the default, foreign key constraints, etc.), and then check the middle table data, no problem to insert a formal table, so conservatively.

CodePudding user response:

Now EXCEL set, then the import