Remote Network And System Administration Job In IT And Networking

Microsoft Access VBA /SQL

Find more Network And System Administration remote jobs posted recently Worldwide

I need an Access program that reads an Excel or CSV file and imports it into Access. The program will prompt the user whether they are importing an Excel or CSV file. It will be unknown how many fields are in the file. The user will need to add the fields into a table. It is unknown how many fields are being imported. But the program will read the table and will calculate the number of fields being imported. The field names will be exact, but may not be in the same order. The actual CSV or Excel file may contain more fields than the ones being imported, but only the fields in the table will be imported.

The applicant must be an expert in Microsoft Access and Access VBA and should be knowledgeable in the following:
* Access VBA
* Access Queries
* Microsoft Azure
* MS SQL
* Access Form & Reports
* Access Modules
* Embedded Access SQL
* Access Database Migration / Conversion

Knowledge of Excel VBA is a plus, but MS Access VBA is the primary skill that I am looking for. I need a someone that can modify and create complex queries and perform VBA coding & debugging. I am also an Access Developer.. This is just the start of the project. I will add the project after this is completed.

I need someone who is fluent in English and I would like to speak to the person and conduct a verbal interview before hiring. I will use Toogit Messages to hold interview.
About the recuiter
Member since May 20, 2018
Altaf Ansari
from Tabasco, Mexico

Candidate shortlisted and hiredHiring open till - Feb 19, 2020

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$34.76

Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

PowerBI, SSRS, SQL developers for Non-profit dashboards and analytics

We are a SaaS software development company that provides donation management software to non-profits. We are looking for an expert PowerBI, SSRS, and SQL developer who will assist in the development of new dashboards and reports.

-Work with...read more

MYSQL Database Optimization

We are currently running a MySQL database that is pulling in data from some of our distributed water treatment plants.

Our dashboard (running Grafana) is slow as the data in the database grows the database continues to slow down and the da...read more

SQL Database Expert Needed

We are a mobile game studio looking to create a BI tool to pull and visualize our data.

We need to pull data from various sources via API and condense the data in Google Cloud and then implement a basic solution to visualize the data.
read more

Mechanical/Electrical Engineer is needed to compare both benchmarking companies in excel format.

Looking for an Engineer who understands well power and water sector and knows how to create a comparison table using excel to compare the services that both benchmarking companies offering.

The purpose of this project is to provide manageme...read more

Need someone proficient with excel to help me clean up a database

I have a database contained within one excel file but spread across multiple sheets. They need to be combined into one spreadsheet.