Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
knindzaaa
Starting Member
2 Posts |
 Posted - 2012-03-20 : 05:20:39
|
| Hi guys,I am new to programming and sql. I have created a web site where users can register and all details are stored on sql 2008 server.I have another list of users on spreadsheet so I am wondering is it possible to import them, and can this cause any side effect.Kind Regards,Knn |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-03-20 : 07:11:54
|
| You can import the data in the spreadsheet to SQL. I would do it something along these lines:1. Create a staging table in your SQL database that matches the columns in your excel sheet.2. Import the data from the SS to the staging table. You should be able to use import/export wizard (right click on the database name in SSMS object explorer and select tasks -> Import data)3. Write a script to examine the imported data (whether it is valid, has all the required fields, whether it duplicates an already existing user etc.) and insert into your table(s) where you are storing the registration information. |
 |
|
|
knindzaaa
Starting Member
2 Posts |
Posted - 2012-03-20 : 07:18:17
|
| Thanks very much for help, I will give it a go.Kind Regards,Knn |
|
|
|
|
|
|
Import Users to SQL datbase ?