Completed

C# Program (MRP) for Monthly Reports from Excel Spreadsheets

We have a collection of spreadsheets produced by an accounting program. Each spreadsheet has one row per Item and 10 columns of data. The spreadsheets need to be parsed into 13 columns, and made into a database. Program can either append a new spreadsheet, in which case the db is cumulative, or the db is created anew to contain all records (one per spreadsheet row) for all spreadsheets selected in the UI. To date, there are about 25 spreadsheets.

First task is to write a C# program to construct the database. The program needs a simple UI to allow controlling which spreadsheets are appended, or included in the database.

Second task is to provide a control on the UI which can access preformatted SQL queries from a file table, and to supply the first report for the first query.

Habilidades: Programação C#, Programação de Banco de Dados, SQL

Veja mais: simple accounting spreadsheet, programming program, programming excel spreadsheets, excel and access programming, excel access programming, excel vba automated monthly reports, custom excel spreadsheets, convert access reports net program, creative excel spreadsheets, business plan free excel spreadsheets, proficient excel spreadsheets, convert pdfs excel spreadsheets, bowling tournament excel spreadsheets, designing excel spreadsheets

Acerca do Empregador:
( 4 comentários ) Lexington, United States

ID do Projeto: #8548597

Concedido a:

hwanghendra

Hi Sir/Madam. Ready to start. Thanks. Our slogan :  ** What we do, you can find elsewhere ** ** How we do it, makes all the difference **

$250 USD em 2 dias
(157 Comentários)
6.4

41 freelancers estão ofertando em média $406 para esse trabalho

Yknox

Hello I'm interesting your project very well I'm a Good C#, Java, DB, Math, Algorithm expert. I m quite well experienced in these jobs. Let's go ahead with me I want to service for you continously. Thanks

$550 USD in 3 dias
(244 Comentários)
8.1
guoxinliu917

Hello, I am .NET and C# expert. I have done many smart utilities for my clients. I am familiar with Excel API to read and write data because I have done many projects that communicate with Excel. Look forward to workin Mais

$250 USD in 3 dias
(82 Comentários)
7.2
NallakumarKC

Hi, I am Nallakumar. I have more than 9 years of experience in C# and Excel Automation. I would suggest you the following, 1. Create a VSTO Excel AddIn using C#, that will create 2 buttons in Excel Ribbon. 2. T Mais

$631 USD in 3 dias
(39 Comentários)
6.9
riskypathak

Hello. So If I have understood the tasks correctly, you want to create a database(probably single table) from all spreadsheets and then there will be different tab where we have control for query file browse and we Mais

$526 USD in 10 dias
(108 Comentários)
7.5
Anuitex

Hello, Thank you for the opportunity to apply to your project. We are the team of IT professionals, who are passionate about what they do. Given our 7+ years experience and deep specialization in .NET developme Mais

$400 USD in 10 dias
(37 Comentários)
7.4
esalem

Hi, I am VB and GIS developer and well versed in Excel and programming of Excel using VBA or even developing Add-in for Excel using VSTO of .NET. I gave also courses in Excel for UN employees here in Palestine - Gaz Mais

$555 USD in 15 dias
(14 Comentários)
7.0
augurstech

Dear employer thanks for giving me opportunity to submit proposal on your project coming to your project requirement we we write the c# program to construct the database with all points mentioned in project details Mais

$315 USD in 10 dias
(12 Comentários)
6.2
okwebsolution

Hello sir, Ref your project description we would like you to share with us the mockup of what you are looking for and possibly the excel sheet with some dummy data on it. we have a vast experience of working on vari Mais

$789 USD in 15 dias
(13 Comentários)
6.2
nikmah344

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 6+ years of experience in Web Development. I have worked on below technologie Mais

$250 USD in 5 dias
(32 Comentários)
5.6
vnb400sl

Respected Sir / Madam i can develop the application in C# to create database(s) from excel spreadsheets and other tasks as needed Warm Regards vnb400

$250 USD in 10 dias
(49 Comentários)
5.4
dobreiiita

Hello I am C# expert and interested in this project. I have reviewed the requirements carefully and confident to handle this project perfectly. Please communicate to discuss further. Regards Anshu

$444 USD in 7 dias
(76 Comentários)
5.7
prashushinde9

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably Mais

$750 USD in 15 dias
(8 Comentários)
4.9
IhorPavlov

I have experience in solving such tasks, therefore I can do it efficiently and quickly. Hope I'll be able to help you with this task.

$250 USD in 5 dias
(4 Comentários)
4.1
JinDongZhe

I've mastered C/C++/C#/Java programming/reverse software engineering and helped many customers . I'm sure I can fulfil your job successfully. I hope our collaboration to produce a good outcome that makes u happy. Best Mais

$250 USD in 2 dias
(5 Comentários)
4.4
denissantos88

Good evening, I have 10 year experience with software development and data migration as well. I presume you are intending to use MS SQL Server to store the data, right? I can develop your solution on time and budge Mais

$555 USD in 7 dias
(7 Comentários)
4.2
MohsanEijaz

I think I am a good fit for this job because I have all the qualities that you are looking for. Experience is the golden factor in this project where you find in me at least 3+ years of working experiences over all the Mais

$250 USD in 5 dias
(2 Comentários)
3.9
atisch

Your task looks like a weekend job. Actually my wife is an accountant and that's just how my usual homework from her looks: "Look, we've got this spreadsheet exported from AMS. But look here - the data in this two co Mais

$277 USD in 3 dias
(1 Comentário)
3.3
SymtecConsulting

Hi, Please understand that this is not a copy pasted proposal. I have vast experience in developing systems that import and export excel. I also have expertise in developing systems on . net framework using c#. I Mais

$250 USD in 2 dias
(9 Comentários)
3.1
SashaPinsk

Dear customer, I am a ASP.NET developer with 2+ production experience. Recently worked with excel. Have strong SQL skills I will complete this task in 7 days. Ready to start immediately. Best regards, Alia Mais

$750 USD in 7 dias
(1 Comentário)
3.2
ExpertSoftTech

Sir I am interested in your project. I am a professional ASP.NET C# developer. I can do this job easily. Even I can do it with in 4 days but my bid is 250 dollars in 7 days because of the risk Management. I hope you w Mais

$250 USD in 7 dias
(5 Comentários)
4.3