Write C# Windows Console application to insert data from excel into MS SQL Server -- 2
$30-250 USD
Paid on delivery
I need a c# console application written that will read connect to a test MS SQL Server database (I will provide the connection string). The program will open an Excel file (I will provide) and read the data row by row (in a loop) and insert each record into the SQL database. Before the insert, the program will merge some cell values into a single value separated by commas, and will change letter values (codes) into strings (mapping is in .jpg). Sometimes the string will be too big for the column, so the data will be truncated at the last full code value before the insert. Some columns in the database will have default values (I will provide). If a row already exists in the database it will be left alone. The program will produce a text file a the end of the run listing: total input records, number of duplicates not inserted, and number of inserted records.
You may not use Bulk Copy, you may not change the structure of the database table, this is a console windows application. It must be written in c#. A milestone of 1/3 of the project cost will be released once the code is reviewed, another 1/3 of the project cost will be released with the code is tested on the test server, and the final 1/3 will be released when the code is put on the production server and working.
I expect that a this project could be profitable at under $100
A question was asked what does merge some cells into a single value separated by commas and change letter values...
The spreadsheet has several columns containing a single letter. The letter A for example means 'water pump', letter B means 'solar energy'. These excel columns must be translated from A, or B, or .... to the text values separated by commas into a single SQL Server column. There are 4 SQL server columns that need to hold these data, and about 25 excel cells (columns) that must be translated. The SQL column has a maximum character size of 100, so the values that is inserted must be truncated to the last whole text value. So the column for the example above would be Insert into xxx values (col1,...) values ('water pump, solar energy'). You cannot insert ('.......solar ener') it must end with a whole element and no trailing comma.
I have attached the code to value translations.
Project ID: #6454911
About the project
33 freelancers are bidding on average $126 for this job
hey there, We went through your description and we are good to implement this in C# (read Excel values, some preprocessing and then insert into mssql Server DB). And you are correct- this is profitable for a 100$ and w More
can u explain this please "Before the insert, the program will merge some cell values into a single value separated by commas, and will change letter values (codes) into strings (mapping is in .jpg)." ?
Hello, I have more than 14 years experience in MS SQL and 7 in C#. Application can be console and all data will be inserted into MS SQL tables. Regards
Hello, i am expert in C# , i did similar jobs before plx send me the connection string , excel sheet to begin i aggree for your payment paln waiting your answer Regards
Hi, I can do this job for you; I will provide long support as well. Will love to work on this project and build long term relations. We are looking forward to hear from you. Thanks and regards!
Software developer since 2000 specializing in Visual Basic, SQL server, and Crystal Reports/VBA for Microsoft Office
Negotiable. Sincerly i don't like this. It is a big error to store data in this format. You should use 3 tables in mssql instead of 1: 1. The current table would be the master table. 2. There would be a table contai More
Hi, I am very efficient in data transformation using user code and I will not use any kind of bulk copy. Please provide me the full requirement with you sample excel file and a database connection. Assume you database More
I have exp of total 7 yrs. in .net C#, worked on ASP.net,Win form,wcf,wpf, now working on windows phone,Store app, android and ios phone app using xamarin,SqLite. Have done project using mvvm cross also. Worked on dom More
hello I can make the script I have four years experience in dot net development with sql server, I'm available