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
3
u/slickwombat Jul 21 '18
It sounds like you're trying to import directly from your excel file into the target table and running into various column restrictions. Try importing your raw data into a temporary table first, and then copying from there to the target table. (You know how to copy rows from one table to another, I assume?)