Need to create a c# .net library to import the CSV file into MSSQL Database (Multiple tables).
Requirements are below:
1) Read the CSV file ( and validate it for the standard sets of columns) . If validated then move to Step 2
2) First import the CSV file in a temporary table.
3) Once inserted in the temp table, compare it the Main Table - based on the some columns that I will provide once the project is confirmed. If match found then update the main table else insert it as new records.
4) In addition, need to match and update other child tables from the temp table.
Note: The flat csv file has approx 200 columns that needs to be inserted in 10-12 tables.
Only bid if you have done a similar project before or can show a working prototype.
66 freelancers are bidding on average $116 for this job
Have already worked on similar project that imports data to sql table fields from csv by following strict set of rules and validations.. I can share screen and demo.
Hi there, I read your initial requirements and I have some questions regarding your Build a c# .net application project. please send me a message so that we could discuss it further.
Hello. I have some experience using Microsoft SQL Server integration with the .NET Framework common language runtime (CLR). All the actions you need will be carried out using a library written in c#.
Hi, My name is Ali and I can work on it with immediate availability. I can show you demo of Excel export to database. Let's have quick discussion so I can work on it.