Import data from excel to table in sql
It worked correctly for me with the below

1- Convert from XLSX to XLS

2- Add incremental primary key at XLS sheet

2- Then save as text Unicode

3- Go to Microsoft SQL then right click on the database then import flat file

4- Convert data types to nvarchar(max) if need it