Companies House API-MS Access Integration

Open Posted 3 minutes ago Paid on delivery • Ends in 6 days

$30-250 AUD

Paid on delivery

Open Paid on delivery • Ends in 6 days

I am seeking a solution to integrate the Companies House API ([login to view URL]) with a Microsoft Access database using VBA. The goal is to retrieve directors' and secretaries' names and store them in a table, using company numbers from another table. Below are the detailed requirements:

Requirements:

1- API Connection Setup:

Establish a connection to the Companies House API using VBA in MS Access.

Let me know what API type and credentials for authentication are needed.

2- Data Retrieval:

Retrieve directors' and secretaries' names using the company numbers from an existing table in the MS Access database.

Ensure the data is accurately parsed and stored in a new table (Optional).

3- Automation:

Develop a VBA script to automate the data retrieval process.

Additional Notes:

Include instructions on how to use and maintain the solution, in case we needed to change the API key.

The solution should be robust.

Experience with VBA, and API integration is essential.

Please provide an outline of your approach.

Microsoft Access Visual Basic Visual Basic for Apps Software Architecture API

Project ID: #39033851

About the project

5 proposals Open for bidding Remote project Active 2 mins ago

Place your bid

AUD

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

5 freelancers are bidding on average $112 for this job

efanntyo's Profile Picture
efanntyo

Hello Osama S. Hope you are doing well! This is Efan , I checked your project detail carefully. I am pretty much experienced with Visual Basic, Visual Basic for Apps, Software Architecture, Microsoft Access and API for More

$100 AUD in 2 days
(5 Reviews)
5.2
Deployyit's Profile Picture
Deployyit

I understand the importance of seamlessly integrating the Companies House API with your existing Microsoft Access database. My extensive experience with VBA and API integration, including projects that involve retrievi More

$150 AUD in 7 days
(3 Reviews)
4.0
ShekharTyagi345's Profile Picture
ShekharTyagi345

With 8 years of experience in VBA and API integration, I am confident that I am the best fit for this project. I have the relevant skills to seamlessly integrate the Companies House API with a Microsoft Access database More

$30 AUD in 7 days
(5 Reviews)
3.2
mmoshinali's Profile Picture
mmoshinali

Hello, I have carefully reviewed the project requirements for integrating the Companies House API with a Microsoft Access database using VBA. With my expertise in Software Architecture, I am confident in delivering a More

$140 AUD in 7 days
(0 Reviews)
0.0
Post a project like this