SQL SERVER

SSMS를 이용하여 Excel 데이터 CTRL + V로 DB에 insert 하기

bedbmsguru 2018. 10. 26. 21:44

Select the data in excel and press Ctrl + C
  1. Select the data in Excel and press Ctrl + C
  2. In SQL Server Management Studio right click the table and choose Edit Top 200 Rows
  3. Scroll to the bottom and select the entire empty row by clicking on the row header
  4. Paste the data by pressing Ctrl + V

저작자표시 (새창열림)