已关闭

Convert Excel to a Database with Reports

I currently have 20 excel worksheets that record 5 data points on 18 different items for the last 10 years. From there I have 125 different columns of information per day. Some are calculations and some are simply true and false. Then I use pivot tables to create reports.

It has become too burdensome doing this with spreadsheets. I would like to convert the whole thing to a database with heavy emphasis on queries and reports. that is the key. I must be able to get reports easily and in combinations that are preset. Another key part will be being able to automatically update the database.

You must be strong in reports and setting up the queries I want in the way I need them, just like I do with my excel worksheets and pivot tables. I currently have Microsoft Access, but I am not opposed to using SQL light if need be.

There are so many calculations per record or row. Some reference a date. Some reference the previous record or row. Some reference future dates or rows. all of the math is simple math, addition, subtraction, dividing and such.

Speaking English will be a plus since its the only language I know.

技能: 数据输入, 数据处理, Excel, 微软Access, Visual Basic

查看更多: convert excel to website, convert excel spreadsheet to web application free, convert excel to web application open source, convert excel spreadsheet to access database 2013, excel database, how to turn an excel spreadsheet into a sophisticated web app, generate report from excel spreadsheet, how to create a summary report in excel, convert dat database file excel, convert excel database labels, reports forms disappeared access 2007 database, convert excel database, using access excel database, service convert excel database, convert excel database linux operating system, access database reports excel, mail database pdf convert excel database, linux convert excel database, convert excel file access database, can convert access database reports ssrs

关于此雇主:
( 0个评论 ) United States

项目ID: #17993502

67 威客就此工作平均出价 $461

schoudhary1553

I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid 更多

$300 USD 在10天内
(305条评论)
7.7
cgullapalli

HI, I am good at SQL database. Please share the requirements of excel files. I will see the possibilities of automation and getting reports from excel files. It helps me in getting the scope of work. Looking forw 更多

$500 USD 在10天内
(804条评论)
7.9
illuminesoft

We have successfully finished over 520 projects in last 18 years. ID : 17993502 Greetings, We are interested to work on this project, please find my comments inline with yours, 1)Convert Excel to a Database wit 更多

$555 USD 在10天内
(258条评论)
7.5
asin1987

Dear Employer, Below are the advantage of working with me: - Expert of Excel. - Expert of SQL. - 10 years of experience of all these stuffs. - Know how to do tough or simple calculations. - Above all, well ve 更多

$555 USD 在10天内
(126条评论)
7.1
paris2785

Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Access because this is my favorite field and MS Access projects are among the tasks I work wi 更多

$700 USD 在7天内
(207条评论)
7.1
sargardon

Hello sir/madam I have developed several Access databases based on Excel files and I am ready to work on your project. I have over 10 years of experience in various database systems like Access, MS SQL Server, Oracl 更多

$600 USD 在10天内
(110条评论)
6.8
priyal1997

Hi There, As an expert in advanced excel features I am happy to help you on this task. I just bred your project description, and happy to say that we can do this task perfectly using pivots and formulas without any v 更多

$250 USD 在2天内
(189条评论)
6.7
polarjin2017

Hello? How are you? I have good skills in So I can complete your job in time. Hope to work with you. Thank you.

$500 USD 在3天内
(71条评论)
6.5
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$750 USD 在10天内
(115条评论)
6.6
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl 更多

$500 USD 在6天内
(118条评论)
6.3
alaeddindhahri

Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you devel 更多

$750 USD 在15天内
(69条评论)
5.8
zu02

Hi, there I hope all's well with you. I'll do your current project via Ms Access - very professionally and on time. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full 更多

$555 USD 在10天内
(51条评论)
6.1
mateenbhatti94

Dear sir I have read the requirements and completely understand the project.I will get you a program that will get you reports in 1 sec and will give you all kind of access.I will build a good User interface based p 更多

$250 USD 在3天内
(52条评论)
5.6
tasleem83

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start

$555 USD 在10天内
(111条评论)
5.5
Grunty

Hello, I've done several projects here involving Excel and MS-Access design, programming and conversion. Please browse my history for some examples: • https://www.freelancer.com/projects/Excel/Stats-Database-Project 更多

$700 USD 在15天内
(39条评论)
5.6
mtdevil369

think i am the Right person who can take responsibility for you project and can complete it according to your REQUIREMENTS, As i got all the skills that you need for this project.I have read your project description ca 更多

$250 USD 在2天内
(68条评论)
5.3
pilotarif

I can perfectly do your project work and able to complete full work in the shortest possible of time with 100% accuracy, perfection and according to your given instruction. I am ready to show you cost-free sample 更多

$277 USD 在0天内
(40条评论)
5.0
natalka503

Hello, I am a programmer and I have years of experience in that kind of projects and I would like to help you. Please contact me via chat to discuss details. Greetings, Natalie

$500 USD 在2天内
(49条评论)
4.6
crypthne

I'm an experience MS Access and vba developer, have been in this field for almost 10 years and working many MS Access or MS Access related project (using other development platforms). I'm also Brainbench MS Access cert 更多

$250 USD 在7天内
(35条评论)
4.7
MentisSoftware

I am a professional developer with over 15 years experience, [login to view URL] Software Development and a Microsoft Certified Professional. I am diligent and produce quality work. I have many years experience with all versions of M 更多

$722 USD 在20天内
(7条评论)
4.3