I have a web application ready with all the test data developed using VS 2008 and SQL Server 2008.
Now, we need to import the LIVE data into our application so that it is ready to use at client site. How this can be done??
Please provide me the steps. I have received the data from client as per the format we required in the Excel sheet.
Also, is there any sp that helps ? where in we can provide the table name and respective column names and the data will be imported in the respectively?
Please help me out. I am doing this kind of stuff for the very first time it will be really nice if i get to know form the bery basics.