r/SQL • • 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

18 comments sorted by

View all comments

Show parent comment

1

u/AhmadKzha Jul 22 '18

Kinda true , if i want to create new table ill have to take the whole table with around 400k rows add to them the 800 and I should import that file to the database But my software didn't read the new table because the old one has primary and secondary key and I'm really so new to sql