• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 107
  • Last Modified:

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 .
0
tonyantony
Asked:
tonyantony
1 Solution
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now