SQL Server showing Null when pasting from Excel even though there are values in cells

Question

I am updating a table in SQL Server Management Studio from an Excel doc by right clicking on the table I want to update, hitting edit top 200 rows, and trying to paste in my new line of data.

However when I do this I am coming up with couple of issues. First of all, the ID column is showing as NULL. Second, the line is read only (that by itself really isn't a problem for me, but it doesn't seem right) and finally some of my columns that do have values are showing NULL.

When I try to import the excel spreadsheet (right click on database, tasks, import data) I get the error shown here.

question from:https://stackoverflow.com/questions/65837401/sql-server-showing-null-when-pasting-from-excel-even-though-there-are-values-in

Answer 1

You must to save excel file to Excel 97-2003 Workbook (*. xls). Then let begin with mapping your fields source to destination table.