C # resolves an issue with importing a database from an Excel table with an identity card number

When you import an SQL database from an Excel table in C #, you find that the ID number imported from Excel becomes a scientific representation.

It is easier to solve this problem, first, open the spreadsheet, select the "ID number" column, right-select "Format Cells", go to the cell format interface, select "Number", select "Text" format. Click OK to return to the original interface. Select the first line of the ID number and add a single quotation mark (') in front of the ID number, for example: ' 450909198812129876

This way, the subsequent ID number is automatically converted to the format. Re-import the database and solve the problem.

Supplement: The identity card number type in the database is best not set to the number category, because the identity card number exists x this character;

C # resolves an issue with importing a database from an Excel table with an identity card number