Excel and Access - Solution for getting data from Access to Excel and updating it easily

Completed Posted 1 year ago Paid on delivery
Completed Paid on delivery

I have an Access database with four separate tables. Each of them have somewhere between 3000-12000 rows of data. I need to be able to set up an Excel spreadsheet so that it automatically retrieves the data from one of the databases (one that is selected at that time) and uses values from certain cells of the Excel spreadsheet as query parameters that give both lower and upper limits for queried values. I need to be able to easily modify these values (by modifying the corresponding cells in the Excel spreadsheet) and update the query results accordingly. I would imagine that this is not too difficult or time-consuming to do for someone who is experienced with similar tasks.

Excel Data Processing Microsoft Access Database Programming

Project ID: #35911030

About the project

47 proposals Remote project Active 1 year ago

Awarded to:

andradastoenica

Hello! My name is Andrada and I am new to freelancing, but experienced in working with data. I can help you automate this task. Once everything is configured, the only thing remaining for you is going to be to press a More

$10 USD in 7 days
(4 Reviews)
2.2

47 freelancers are bidding on average $21 for this job

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am a More

$80 USD in 2 days
(560 Reviews)
8.5
pakee

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power More

$28 USD in 3 days
(250 Reviews)
6.8
zu02

Hi, there I hope all's well with you. I was very interested in your project. I can solve your problem via MS Access with Excel automation. Can you provide more details? I am an Access/Excel/SQL/VBA expert and mathem More

$30 USD in 1 day
(82 Reviews)
6.5
eduardoherreral4

Hi I have read your description carefully. I have rich experiences in ⭐ MS Access, Database, SQL, Excel, Web Scraping, formula, vba, macro, data entry. ⭐ I worked on many similar projects. I can guarantee the quality o More

$20 USD in 1 day
(12 Reviews)
4.7
Noman4077

I have experience and good grip on Data processing.I can do your task quickly and in smart budget. Also i can show you my some previous work contact me Thank you !

$10 USD in 1 day
(2 Reviews)
2.3
Usamaoutsourcer

Hey there, I am writing to express my interest in your project of editing your Access database and setting up an Excel spreadsheet. I have extensive experience in working with both Access and Excel, and I am confide More

$13 USD in 1 day
(1 Review)
2.0
preitymathur0422

Hello, I had almost 15+ years experience working with various excel automation and various database(s) Available to start work immediately in case project is awarded.

$20 USD in 7 days
(3 Reviews)
2.1
freelanceruzair

Dear Client I am an experienced Microsoft Access database developer and I specialize in providing data automation and transfer services. I have extensive experience in designing and implementing custom solutions using More

$20 USD in 2 days
(1 Review)
1.6
ranjithgvarun96

Dear Hiring Manager, I have all the required skills like MS Excel, MS word, Tally for GST, Tally ERP, and working in google sheets too. As being a skilled data entry employee I would like to offer myself as a candidat More

$10 USD in 2 days
(5 Reviews)
0.6
SyedRohaanAlam

Hello, I have more than seven years of experience in the office and more than three years of freelance experience in the required task and would like to help you with this task. Thanks for posting in my area of work.

$20 USD in 999 days
(0 Reviews)
0.0
aniketjujagar

My name is Aniket. I am writing to you for the position of data entry expert that you are looking for an urgent basis. Data entry job is my passion and I have 6+ years of experiences in this field that makes me confide More

$20 USD in 7 days
(0 Reviews)
0.0
zosimuddinrj

hi I am data entry expert. I understand what you want. I understand what you are doing. I would be happy if you could tell me the details. I have experience in this work.

$20 USD in 7 days
(0 Reviews)
0.0
gustavoalias

Dear customer, I have carefully read the requirements and I can achieve the objective using the VBA language, in such a way that you can choose the range to be extracted from the Access database and copy it to a specif More

$20 USD in 7 days
(0 Reviews)
0.0
mdarifhossain533

I am a Professional Data entry specialist. I am doing this work many more time for urope clint. So please give me an opportunity to prove my Self that how much expert I am on it

$15 USD in 5 days
(0 Reviews)
0.0
ZAHID56

Hello. I read your requirements i will do that. Please come on chat we will discuss more about this. I will waiting your reply.

$20 USD in 1 day
(0 Reviews)
0.0
asadhussaini

I may able to help you with your requirement. I am having experience with Access to Excel connections along with filtration/parameters.

$20 USD in 7 days
(0 Reviews)
0.0
ManojKumarpat

i working Couple of hours on excel in a day ... i have good knowledge on excel formula , spreddsheet

$20 USD in 2 days
(0 Reviews)
0.0
khairyemad10

I am Excel VBA Advanced Level Expert. This is basic work for me. I can complete this project with added quality Hi there, I am an experienced Data Collector & I can handle this task very efficiently. Let's discuss more More

$10 USD in 1 day
(0 Reviews)
0.0
phiadriani

Dear Tenant, I'm expert in data entry and copy typing that's probably match with the requirement in your project. I would like to hear more about the project,and if you interest in my offer please kindly message me thr More

$20 USD in 2 days
(0 Reviews)
0.0
miramedhat22

Dear hiring manager, I hope you are in good health condition. I have studied all the details about your job posting on Data Entry Project just moments ago. After studying your Job Description,I understand that you ne More

$20 USD in 7 days
(0 Reviews)
0.0