Paste MS Excel data to SQL Server
If you have SQL Server Management Studio, you can just Copy from Excel and Paste into the table in Management Studio, using your mouse. Just Go to the table you want to paste into. Select “Edit Top 200 Rows”. Right-click anywhere and select Paste. Before you do this, you must match the columns between Excel … Read more