Find Jobs
Hire Freelancers

Convert Excel to a Database with Reports

$250-750 USD

Closed
Posted over 5 years ago

$250-750 USD

Paid on delivery
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.
Project ID: 17993502

About the project

56 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
56 freelancers are bidding on average $473 USD for this job
User Avatar
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 versed with Engish. Please do message me. I can do any job that you may need on SQL,Excel etc. You may like to check my reviews once!! :) Thanks and Regards, Ash
$555 USD in 10 days
5.0 (301 reviews)
8.4
8.4
User Avatar
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 with regularly and know exactly how to handle them. You mention that you need somebody to convert your Excel spreadsheet into an Access database with emphasis on queries and reports that will substitute your pivot tables. I'm going to spend less than a week to complete your project including required revisions for a total payment of $700. I never ask for any payment in front. I claim the milestone release once the project is completed and my client is happy with the result. I'm a very experienced and skilled MS Office developer as you can easily check for yourself. You're welcome to visit my personal page on this platform and get an idea of who I am and what services I deliver to my clients. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$700 USD in 7 days
5.0 (625 reviews)
8.6
8.6
User Avatar
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 forward to discuss and work on the project. -Chandra
$500 USD in 10 days
5.0 (1248 reviews)
8.5
8.5
User Avatar
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 or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Data Entry, Data Processing, Excel, Microsoft Access, Visual Basic. Please ping me for more discussion.
$300 USD in 10 days
4.9 (589 reviews)
8.5
8.5
User Avatar
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 • https://www.freelancer.com/projects/Excel/Build-Historical-Stats-Database-Using • https://www.freelancer.com/projects/database-programming-Database-Development/DJP-database Especially the first two (2nd was an appendix to 1st) are flagship projects -- high quality and robustness, taking full advantage of features MS-Access offers (but seldom used) to ensure data integrity accross the data tables. A well-thought suite of queries provided a set of statistical and historical results and rankings, from granular to total levels. Are all your 20 worksheets the same data format? This may affect the amount of work needed to build the modules that will populate the database. I will propose splitting the work into 2 or 3 milestones, which I will be pleased to explain if we get to discuss further details of your project. Looking forward to your contact, Grunty.
$700 USD in 15 days
5.0 (66 reviews)
7.9
7.9
User Avatar
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 with Reports =>Ok 2)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. =>OK, can you provide sample Excel file. The format of the Excel is going to be fixed ? or going to change over period or regularly ? how do you want to input data to the database ? Do you want forms to input one record by one ? or bulk copy paste from Excel data ? or you want to directly import this excel files let me know? how many types of formats you want to import ? Is there any unique field in the excel so that we can understand duplicate values. Does your excel has images embedded ? or it has path of the image file ? I will prefer if its image path in excel and images in a folder on disk etc. If the images are embedded on the excel sheet, it becomes difficult to bring them in MS Access report.   3)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 ab
$555 USD in 10 days
5.0 (260 reviews)
7.5
7.5
User Avatar
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$750 USD in 10 days
4.9 (136 reviews)
7.2
7.2
User Avatar
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 possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$500 USD in 6 days
4.9 (265 reviews)
7.2
7.2
User Avatar
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, Oracle, MySql, Sqlite. Please contact me to start discussion about the project. Best regards, Tolib
$600 USD in 10 days
5.0 (123 reviews)
7.2
7.2
User Avatar
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 in 3 days
4.8 (109 reviews)
6.8
6.8
User Avatar
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 vb or macros. You may refer my profile to see my reliability, and if you are happy with all, lets discuss the project. I look forward to hearing from you. Best regards Priyal
$250 USD in 2 days
5.0 (200 reviews)
6.7
6.7
User Avatar
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 in 2 days
5.0 (72 reviews)
6.5
6.5
User Avatar
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 time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$555 USD in 10 days
4.7 (83 reviews)
6.5
6.5
User Avatar
Dear Client, I can complete this project in short time with quality and your budget. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I would love to work on your project as I have worked on similar projects before. I have 3+ Years of Experience as a Professional Data Entry Specialist. Let’s have a quick chat to discuss this project. What I have done before:- Data Entry of Printed and Hand Written Material Medical Billing Data Entry Data Entry of E-books Insurance Claims Processing OCR Conversion Accounts Payables and Receivables Entry Accounting Book Keeping Records Please feel free to ask if you have any questions . I am looking forward to discuss with you regarding the project. Thanks & Regards, Rahul Anand
$250 USD in 2 days
5.0 (112 reviews)
5.9
5.9
User Avatar
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 develop convert those sheets into an Access app. I have done many projects of the same kind that you can see on my profile. However, I'd like more details about the project. Check my profile for previous clients' reviews and projects. PS: please note that you added Excel and Data Entry in your project skills, this will flood your project with unreliable bidders who come from Excel Data Entry background and not Access developers. I speak fluent English. We can have a call to explain everything if that's better. Looking forwards to hearing from you. Best, Alaeddin
$750 USD in 15 days
4.9 (72 reviews)
5.9
5.9
User Avatar
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 in 10 days
4.7 (115 reviews)
5.5
5.5
User Avatar
Hi there, Microsoft Access can handle all your tasks very easily. SQL as backend and MS Access as frontend will be a right combination if you have a vast dataset otherwise MS Access can handle a mid-level. However, could you please share me your excel files so that I can have a look and give you better solutions. Project specifications: 1) Professional and neat user forms to add/edit records 2) Import data from various source especially from excel 3) Attractive reports 4) Queries and functionalities like to search through the database and pull the matching result. This is what I can think of as your requirements. Please let me know if I missed anything. Thanks, Rayyan
$600 USD in 15 days
4.7 (24 reviews)
5.1
5.1
User Avatar
Hi, I am interested. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Regards.
$470 USD in 5 days
4.9 (11 reviews)
4.9
4.9
User Avatar
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 work for the project right now. I can say undoubtedly that I am the right person for whom you are looking for the project. Let’s discuss in PM so that we can start working on your project right away. I am waiting to have your quick positive reply. Thanks.
$277 USD in 0 day
4.8 (41 reviews)
5.1
5.1
User Avatar
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 certified. I'm confidence I can help you to finish this project for you as requested.
$250 USD in 7 days
4.9 (36 reviews)
4.7
4.7

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Aug 3, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.