C# Class Library
Budget: $30 – $250 USD
I need a C# .NET class built that will take an excel file and load it into a SQL table.
It should have the following variables:
File – Excel File
SheetName – The sheet within the Excel File
HeaderRowIndex – What is the header row number
HeaderRowSpaces – Wheather to remove to keep the spaces in the header row
DuplicateColumnDelimiter – Remove Duplicate Columns
TransactionIdProperty – A property name that is going to be within the SQL table where the transaction ID will be stored.
TransactionIdValue – The transactionID that is going to be stored with each record that is loaded into the table.
SQL Server Name – Server where the data will be stored
SQL DB Name – SQL Database name where the data will be stored.
SQL Table Name - SQL Table where the data will be entered from the excel file.
InsertType - (All at once), (1000 records per transaction), (1 row at a time)
LogErrorstoFile - (True), (False)
It should skip rows with errors, and in the end in the results it should show which rows were skipped and which columns caused the error, or what the error was. Error should log to a file, if LogErrorsToFile is enabled. A demo class type will be provided to give you an idea of how I want this class information setup and what it should look like.
It should have the following variables:
File – Excel File
SheetName – The sheet within the Excel File
HeaderRowIndex – What is the header row number
HeaderRowSpaces – Wheather to remove to keep the spaces in the header row
DuplicateColumnDelimiter – Remove Duplicate Columns
TransactionIdProperty – A property name that is going to be within the SQL table where the transaction ID will be stored.
TransactionIdValue – The transactionID that is going to be stored with each record that is loaded into the table.
SQL Server Name – Server where the data will be stored
SQL DB Name – SQL Database name where the data will be stored.
SQL Table Name - SQL Table where the data will be entered from the excel file.
InsertType - (All at once), (1000 records per transaction), (1 row at a time)
LogErrorstoFile - (True), (False)
It should skip rows with errors, and in the end in the results it should show which rows were skipped and which columns caused the error, or what the error was. Error should log to a file, if LogErrorsToFile is enabled. A demo class type will be provided to give you an idea of how I want this class information setup and what it should look like.