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 |
|
atmonline
Starting Member
14 Posts |
 Posted - 2008-06-10 : 20:01:56
|
| I am new to programming.i have come up with a porject which i don't know how to solve iti have to import data from excel file to sqlserver 2005.The business logic for the import is as follows.i have one excel file Applicant.xls appliantid firstName last name etc.. 1 , mathew1 , jacob1 2 , mathew2 , jacob2 3 , mathew3 , jacob3 4 , mathew4 , jacob4 5 , mathew5 , jacob5another excel file cleed jobmatrix.xlsApplicantid jobid 1 , 100 1 , 123 2 , 100 3 , 101 3 , 103 3 , 104 4 , 101 5 , 156now i have to enter this data in ot 5 different tables based on the following logic.1, create an account for each applicant (userid autogenerated)2, create a masterprofile using this userid from useraccount3, create a application using userid(applicationid autogenerated)4, create a personal profile for based on applicationid (profileid)5, create a resumereceived based on the profielid if the applicant applied for more than one job then application,personalprofile and resumereceived should be created fro each jobthat is for applicant one i have to create 1 user account 1 masterprofile 2 applicatins 2 personalprofiles 2 resumereceived |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-11 : 00:29:21
|
| You can design a SSIS package for importing the data from Excel sheets to two intermediate tables. Then you can have a stored procedure that will do the creation of various table records for each applicant.You can use OUTPUT clause to get the generated ids for each insertion and use it to insert to next tables. |
 |
|
|
|
|
|
|
|
Data Import