I have a little medium to complex requirement on uploading / Importing data from the spreadsheet to the SQL Server table.
Please refer my attachments for the tables structure and data
The spreadsheet will have a employee firstname and lastname which has to be looked for matching records in the EE_Master, Team table and the Employee ID, Team Id, startdate, endDate will be taken out and kept in the new table called TM_ImportMembers
. Rest all other data should be a direct import by column matching if available or put NULL
My primary goal is to import good records from the spreadsheet and upload it in the TM_ImportMembers
If I have a two or more employees , then i need alert the user and skip an update for this user.
As of now we will have only data for the TeamID 5 (just to make it simple)
Files / Sample data
1. The three majors tables that i use are in the ( Table-Structure.txt
2. Sample data for the import in to TM_ImportMemberstable ( Sample Data to be imported to TM_ImportMembers_Table.xlsx
3. The file should be uploaded by a File upload control in C# and good matching ones will be shown in one gridview and bad ones are shown in bad records grid view