We need a C# class library to be developed to import the Excel file into the database.
The requirements are as follows:
>Validate the excel files for all the columns.
>Application Server wouldn't have microsoft excel installed on the server, so create the class library that can read excel file independently.
>Read the records from the excel and match with existing records in the database. If match found then enter the records from excel as child records in the related tables. If it doesn't match then create the parent record in the database and then enter the records from excel as child records in the related tables.
Sample excel file and DB schema will be provided later.
47 freelancers are bidding on average $198 for this job
HI, I have a .net program that can read XLS files and upload into SQL server DB, I will customize it to do the matching and creation of parent records I can show u a demo for my program as soon as you contact me.
Hi there, I can build a c# class library for the excel data matching. We have a team of .net expert who can help you.I can create a free demo for you. Please ping me to discuss more.
Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards
I have many experiences C# , MSSQL. I have done several projects similar as yours. I can show you my projects via chatting. I can complete your project successfully. Thanks.