jth41 jth41 - 7 months ago 48
SQL Question

Moving data from Excel to SQL Server table

I have a very Simple excel sheet:

enter image description here

I am wanting to put this data into a table in SQL Server. I also wanted to add a field that contains a date.

what is the best way to do this?


You can first create the table in SQL Server with the added field and then use the import wizard in the Mangement Studio for importing the excel file. Or you create the table during the import task, and you add the new field later.