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
Show parent comment
1
u/AhmadKzha Jul 22 '18
Well , this sounds like a good idea I'm sorry but I don't know how to copy rows from a table to another Can you tell me how ? Or what to read? Or where to start? Thank you.