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 Mar 14, 2020
Yuvam
from Bavaria, Germany

Candidate shortlisted and hiredHiring open till - Jun 29, 2022

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$34.68

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

SIMPLE EXCEL SPREADSHEET DEVELOPMENT

We are looking for someone to help to create a data analysis spreadsheet for analysing property development deals.

In the first instance this will be quite straightforward. About 4 - 5 tabs. I have the basics completed already it needs tidy...read more

Access DB with Excel Report

Hello, we have an existing access database that pulls information from our ERP (Sage 100 (Formerly MAS 200) The database queries sales data from our ERP and compiles it on a table via various queries. From there the information is copied from acces...read more

Data Analyst - Mobile Games

Hi there! Are you a SQL expert with experience in mobile gaming industry? Are you able to ask smart questions and get your answers from data? If yes, we would love to talk to you!


About us:
Megarama is one of the top employers on To...read more

Cost / Pricing Analysis

Every month I need to analyze the cost of all my suppliers than determine which items which which suppliers should be set to preferred. We need to also filter in freight programs and rebates to ensure we choose the best options for the preferred and...read more

Database needed for Rental company to track return orders

Writing a program that works with QuickBooks and many of my workers can access it on the same time to enter information, many reports to be created