what is the best way for someone with from excel to import in sql server 2012,x64 ?

i am exporting a table from nopcommerce database sql server 2012, to excel , from management studio and do my editing ,now i need to imported ( appent , or rebuild ) to the database table, but in the same time to rebuild the table-setting,(keys,columns, constaints, triggers,,indexes)  , what is the best way to do that ? is there a automatic duplication way of the table design, can i use a better program for that?
i am not a programmer ,i need plain directions
thanks .
tonyantonyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Michael FowlerSolutions ConsultantCommented:
To import data from Excel to SQL Server including rebuilding the table use SSIS if you want a repeatable process
http://www.mssqltips.com/sqlservertutorial/200/sql-server-integration-services-ssis/
https://msdn.microsoft.com/en-us/library/ms169917.aspx

If this is a once off then the easiest way would be

1/ Make the changes to the table SQL Server Management Studio. This will probably require you to drop and recreate the table. Right click on the table and select
Script Table as > DROP And CREATE To > New Query Editor Window
This places a script in a new window which will first delete (ie drop) the table and then recreate it. Just make the required changes to script and run it and the table will be recreated with the settings you specified.
2/ Import the new data. Right click on the database and select
Tasks > Import Data...
This opens wizard which will lead you through the process

Neither of these two option require programming as such but do require some knowledge of SQL Server and relational databases.

Of course it should go without saying that you need to do a full back up of the database before starting.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.