coldfusion upload spreadsheet into the databse
I have the spreadsheet from which I need to extract data and put it into the sql database. This is for the survey. The sql insert should constructed such a way so when the role is Self then the mapping should be created and put people who is underneath of that person name until the next Self person. I am attaching the spreadsheet
The data table where the data need to go is here
The data table where the data need to go is here
id surveyID rateeID raterID relationshipToRatee groupID
329 3 125 125 1 1
330 3 125 126 2 1
331 3 125 127 3 1
332 3 125 128 2 1
333 3 126 125 1 2
334 3 126 126 2 3
335 3 126 127 2 2ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
User must provide more information and description about the problem. Othervise this question can be closed.