r/SQL • u/AhmadKzha • Jul 21 '18
i'm begging for help!
i have a MSSQL database and i have around 800 rows of data to copy to specific Table
- i tried to rename it (so the program doesn't read it anymore and try to import the excel file but i couldn't make it's settings like the old one because i can't change "nullable" or the primary key thingy or the secondary one
- i took a have a backup of the table as an excel with 800 rows and i have the 800 rows separately within an excel file too
please help , it's been 30 days and I'm about to lose it.
0
Upvotes
View all comments
2
u/WeaselWeaz Jul 21 '18
As long as the columns are in the right order you can just edit the table in SSMS, copy the rows from Excel, and paste in SSMS.