Import data from excel to table in sql Please I have issue that when I try to import data from excel to table in SQL it fails with below errors even I modified all the tables in the tables to be nvarchar(max) and I tried to enter dummy data in the first row
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