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 : 19:56:39
|
| 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 called 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 tp 5 differet tables based on the following logic.1, create an account for each applicant(userid)2, create a masterprofile using this userid from useraccount(step 1 )3, create a application using userid(applicationid)(step 1)4, create a personal profile for based on applicationid(step 3)5, create a resumereceived based on the profielid (step 4) if the applicant applied for more than one job then application,personalprofile and resumereceived should be created for each jobthat is for applicant 1 i have to create 1 user account 1 masterprofile 2 applicatins 2 personalprofiles 2 resumereceived |
|
|
|
|
|
referential integrity