Cancelled

MS Access and Excel Integration

Create a simple excel spreadsheet with data to update the database. This can hold any type of data to be used in this database.

In MS Access

1. Create a form (frmUpdateMediaLink) to link the spreadsheet to a table in the database

2. Create a form (frmUpdateMedia), write a VBA code to extract the data and display it in a listbox, dropdownbox or any from of grid

3. Integrate the spreadsheet data into the application. The spreadsheet should contain new DVDs.

4. Write code to update the inventory DVD table, from the list.

Skills: Excel, Microsoft Access, Visual Basic for Apps

See more: write vba code extract data display listbox dropdownbox, vba code extract data display listbox dropdownbox grid, create form frmupdatemedialink link spreadsheet table database, integration access excel, vba write access table spreadsheet, vba code extract data display listbox, frmupdatemedia, ms access excel vba, microsoft excel spreadsheet, microsoft vba, microsoft excel vba, excel 2013 vba, vba code excel, VBA and excel, vba access excel, simple excel, MS Access VBA, ms access 2013, microsoft access vba, excel inventory, excel 2013, application microsoft access, data integration excel, form update excel, create access database spreadsheet

About the Employer:
( 55 reviews ) Salem, United States

Project ID: #4163115

21 freelancers are bidding on average $116 for this job

fastudiovw

I have 20+ years of experience programming ms-access, .net & sql server. At your disposal for any doubt or question, Regards Fabio

$175 USD in 5 days
(619 Reviews)
7.1
mantislin

Hi sir, please check PM, thx Kimi.

$248 USD in 5 days
(28 Reviews)
5.4
pierreho

Hi Morigeau, I often run SQL in excel applications. See my private message.

$200 USD in 5 days
(23 Reviews)
4.7
winnet21

Hi, I have experience with this project, I happily if work with you in this project. Best Regards

$75 USD in 2 days
(10 Reviews)
4.7
cosconeaionut

Hi ,I can finish until tomorrow . Contact me if you need me! Best regards!

$30 USD in 1 day
(6 Reviews)
3.6
weonlydo

Hello, I am going to take your words at face value that those are exactly the 4 things you need done, no more no less. I will deliver one Excel spreadsheet and one Access database fulfilling the requirements.

$125 USD in 2 days
(5 Reviews)
3.4
MarlinSoftware

Could you please clarify 'This can hold any type of data to be used in this database', are you saying the spreadsheet columns could change? i.e. Title, Rating, Format etc. wouldn't remain static

$150 USD in 5 days
(2 Reviews)
3.1
shaarawi

I can do it

$100 USD in 3 days
(9 Reviews)
2.7
nibiranijum

Hi, I am access and excel expert. I can help you best. Please check my profile to see my previous work history. Rgds, Shafiq

$150 USD in 3 days
(1 Review)
2.6
kami7644

Hi, Ready to start your work. Eagerly awaiting for your positive reply. Please check your inbox for further details. Thanks

$40 USD in 2 days
(5 Reviews)
1.6
TBSGADI

Hi, I'm a Senior Access Database and Excel VBA Developer. I'm new to this site, but have 20 years experience in developing and maintaining applications,many with features similar to the one you're requesting. I'm hard- More

$150 USD in 7 days
(0 Reviews)
0.0
gighi1991

hire me :D

$200 USD in 3 days
(0 Reviews)
0.0
LimMeiCin

I've experience in this kind of job. Please check PMB. thanks

$30 USD in 1 day
(0 Reviews)
0.0
iacovos

Hi, I am a proffesional programmer with many years of experience in the requested technologies. Ready to begin asap. Waiting for your response

$50 USD in 2 days
(0 Reviews)
0.0
ambatiraghu

i am looking for data entry job please send data

$30 USD in 1 day
(0 Reviews)
0.0
Itdap

Hello Sir, My name is Diego and I have 14 year of IT experience. I have the following certifications: MCITP, MCP, MCTS and STS also coursed CCNA, MCSE and MCDBA. I provide all kind of support services including: Micr More

$30 USD in 5 days
(0 Reviews)
0.0
struggler1

right now. ok

$50 USD in 0 days
(0 Reviews)
0.0
justinjojola

I have over 10 years experience with MS Access. I am the Access guru! I look forward to working with you.

$150 USD in 1 day
(0 Reviews)
0.0
ResonanceIT

I can give you quality and on-time delivery. Interested in working with you in this project.

$250 USD in 7 days
(0 Reviews)
0.0
rusiruharshitha

Hi, I'm a CCNA & MCSE certified network engineer from Sri Lanka. I can do your database assignment. I'm a fresher for freelance.com but, having experience in DBMS.After you get satisfied about my work, do me the paym More

$100 USD in 7 days
(0 Reviews)
0.0