Closed

Access DB - SIG Macro

4 tasks

(1) - Convert an excel macro to run in ms access on large files. Macro works on small files but some exceed excels limits.

(2) improve code efficency to search for keys to label columns in data rather than hard coding column layout (allows data extracts with changes to column order)

(3) allows data to log error and continue rather than crashing (debug) when an input field is not in expected format. (ie ip6 address instead of IP4 as expected in code)

(4) look to improve time to run macro. Some files can be 1million lines long and take a couple of hrs to run

Other seperate VBA based code /macro work will follow if successful.

Skills: Excel, Visual Basic, Microsoft Access, Visual Basic for Apps, Data Processing

See more: how do you create a database switchboard in access, windows digital signature, azure digital signature, capture signature in access database, digital signature on excel, how to digitally sign a macro, word signature certificate not trusted, certificate signature, access macro log error, search access database word macro, linking word document access database using macro, access 2007print pdf macro, access db, access db accounting software, access db consignment shop, access db drupal page, access db elogging, access db front end design, access db googlemap, access db import csv vb

About the Employer:
( 2 reviews ) Sydney, Australia

Project ID: #25641675

25 freelancers are bidding on average $202 for this job

VladimirLilenko

Hello! I am ready to carry out your project in the reasonable price and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Access, of More

$110 AUD in 1 day
(203 Reviews)
6.8
wsh2

At your earliest convenience, please provide a brief description of what this workbook is attempting. Many thanks in advance! Greetings Australia from the USA.. {smile} Highly experienced (25+ years) MsACCESS/MsEXCEL More

$336 AUD in 7 days
(58 Reviews)
6.6
rinabuoy13

Hello, I am an independent, experienced excel / vba expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

$200 AUD in 7 days
(111 Reviews)
6.4
royalcalif

I would like to discuss little bit more about the project for appropriate duration and cost as well. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy r More

$30 AUD in 1 day
(123 Reviews)
6.3
narsim3128

NOTE : I HAVE EXPERTISE IN VBA AND EXCEL MACROS. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully comp More

$100 AUD in 4 days
(48 Reviews)
5.8
NeilSargent

I looked at your existing macro in some detail and I’m not surprised it is slow. Free tip: it pauses on each row for 1 second just to display progress. For a 60,000 row full that would cost 17 minutes of wasted time. J More

$1000 AUD in 7 days
(9 Reviews)
4.9
dhanrajkarthick

Hi there, Gone through your requirement of migration of excel database to Access database. Have done lot of projects related to this. Kindly go through my profile and and reviews and come back for the chat to discuss More

$140 AUD in 7 days
(15 Reviews)
4.3
braincenter

Hello, Hope this message finds you well, I checked your details and I believe that my experience is what you are looking 4. I have been working on similar projects for the past eight years, and I have the essential sk More

$200 AUD in 7 days
(3 Reviews)
4.0
Bsram88

There are major optimization technique in access / excel vba have to follow when dealing with large data's. Can you send the file, Let me verify and do the change as per needed. Ram.

$70 AUD in 3 days
(10 Reviews)
3.6
(2 Reviews)
3.2
khaldalfalah

Hi, I am ready to convert your excel vba to access vba. I have experience in MS SQL server, asp.net, crystal reports and VB.net more than 12 years. Other skills: Access vba, Excel vba, C#, Php, my sql , technical & S More

$250 AUD in 7 days
(11 Reviews)
3.4
Nosratabouhamzeh

Hi dear sir/madam, I'm very active and interested to work with you. My time is up to you. I have many experiences in this case and you could award your project to me and enjoy it. With best regards

$250 AUD in 1 day
(3 Reviews)
1.7
leiyonz

Leave a message and more detail info to work on then I can show you some result in few hours Bring it on... I have been playing with: Data Warehouse | ETL | Business Intelligence | Analytics | Data Insights | Databa More

$205 AUD in 3 days
(0 Reviews)
0.0
Gkhantrading1

I am expert in working MS word, Excel, PowerPoint presentation and data typing work and have been doing this kind of work for last 5 years. I am very confident that i would be able to deliver the project on time with 1 More

$140 AUD in 4 days
(0 Reviews)
0.0
LynnChester

Good day. Thank you for your detailed spec and sample file. I'm highly experienced in Excel (18+ years' experience), working with VBA and other advanced Excel functionality on a daily basis. I have completed many simil More

$190 AUD in 5 days
(0 Reviews)
0.0
wzohair

I would suggest a better approach out of expperience. Option 1> try to convert the whole process into ms access database driven process. This means we will use ms access for your data manipulation (searches, ... etc.) More

$140 AUD in 30 days
(0 Reviews)
0.0
RequenaP

Good morning, I am Pedro Requena, I am a Business Administrator and Visual Basic Specialist, I was reviewing your need and I have several suggestions: 1 The macro is very overloaded with recorded code, so it is not fu More

$250 AUD in 5 days
(0 Reviews)
0.0
$167 AUD in 8 days
(1 Review)
0.0
sharmaakhilesh99

Hello I would like to help you in this project. I have 10 yrs experience in ms access programming. regards Akhilesh Sharma

$222 AUD in 3 days
(0 Reviews)
0.0
JenCaparas23

I used to work as accounting staff here in the Philippines, and I may say that I am suitable for this work because i used to do things such as Data Entry, encoding, Excel, as well as Bank Reconciliation. I am new here More

$140 AUD in 5 days
(0 Reviews)
0.0