I need a C # script to import two excel spreadsheets (Template 1 and Template 2 attached) into an Azure SQL Server. This script should do the same as the OPENROWSET command does. All rows and columns must be imported without any processing.
There will be two milestone payments. Half when the script is delivered and half at the end of the validation, if all the tests run successfully, including performance.
A simple form windows should be built as ”Form 1” file to run the script.
• The import should last less than 30 seconds on a standard internet connection (5MB), both for physical or temporary tables
• The first column of the tables must be an identity (int, 1,1)
• Destination tables must have always 12 columns. If the row of the worksheet does not have 12 columns, the remaining columns of the table must be null
• Some columns in the spreadsheet are displayed differently than their content, such as column “C376” of file “Template 1”, where the displayed value is "135: 06: 00" and the formula bar is "05/01/1900 15:06: 00 ". The value that should be imported into SQL Server is "135: 06: 00"
23 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hi! I'm interesting your project very well. I am mastering c# and sql. And also I have many experience and good skill about web development. Let's go ahead with me
Hi, there i read your initial requirements and i have some question regarding to your import from sql [login to view URL] can we discuss it on chat ?
I am an engineer and confident of what I can do and deliver. I can work on Arduino, Python, Matlab, Java among others. I am asking for a chance to work with you on your project. Thanks
Hi, I see you are looking for c# expert, you can hire me to complete your requiremenrs. Please visit my profile to proof that I am worthy. Thank You
Hi there, I am a senior software developer who major in sql and c#. Please contact me if you are looking for a freelancer who is reliable and capable. Looking forward to your reply. Regards
i am interested in your project and i have read through. i have extensive commercial and ordinary coding knowledge of c#. i can code and import excel to your requirement.
I have done a lol of work on importing csv,excel file into sql server.I can deliver you a good optimaize script for that and you can make me the payment after completetion Thanks