Cerrado

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.

Habilidades: Excel, Visual Basic, Microsoft Access, Visual Basic para aplicaciones , Procesamiento de datos

Ver más: 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

Información del empleador:
( 2 comentarios ) Sydney, Australia

Nº del proyecto: #25641675

25 freelancers están ofertando el promedio de $202 para este trabajo

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 Más

$110 AUD en 1 día
(203 comentarios)
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 Más

$336 AUD en 7 días
(58 comentarios)
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 en 7 días
(111 comentarios)
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 Más

$30 AUD en 1 día
(123 comentarios)
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 Más

$100 AUD en 4 días
(48 comentarios)
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 Más

$1000 AUD en 7 días
(9 comentarios)
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 Más

$140 AUD en 7 días
(15 comentarios)
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 Más

$200 AUD en 7 días
(3 comentarios)
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 en 3 días
(10 comentarios)
3.6
(2 comentarios)
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 Más

$250 AUD en 7 días
(11 comentarios)
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 en 1 día
(3 comentarios)
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 Más

$205 AUD en 3 días
(0 comentarios)
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 Más

$140 AUD en 4 días
(0 comentarios)
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 Más

$190 AUD en 5 días
(0 comentarios)
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.) Más

$140 AUD en 30 días
(0 comentarios)
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 Más

$250 AUD en 5 días
(0 comentarios)
0.0
$167 AUD en 8 días
(1 comentario)
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 en 3 días
(0 comentarios)
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 Más

$140 AUD en 5 días
(0 comentarios)
0.0