Ditutup

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.

Keahlian: Excel, Visual Basic, Microsoft Access, Visual Basic untuk Aplikasi, Pemrosesan Data

Lihat lebih lanjut: 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

Tentang Pemberi kerja:
( 2 ulasan ) Sydney, Australia

ID Proyek: #25641675

25 freelancer menawar dengan rata-rata $202 untuk pekerjaan ini

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 Lebih banyak

$110 AUD dalam 1 hari
(203 Ulasan)
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 Lebih banyak

$336 AUD dalam 7 hari
(58 Ulasan)
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 dalam 7 hari
(111 Ulasan)
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 Lebih banyak

$30 AUD dalam 1 hari
(123 Ulasan)
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 Lebih banyak

$100 AUD dalam 4 hari
(48 Ulasan)
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 Lebih banyak

$1000 AUD dalam 7 hari
(9 Ulasan)
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 Lebih banyak

$140 AUD dalam 7 hari
(15 Ulasan)
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 Lebih banyak

$200 AUD dalam 7 hari
(3 Ulasan)
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 dalam 3 hari
(10 Ulasan)
3.6
(2 Ulasan)
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 Lebih banyak

$250 AUD dalam 7 hari
(11 Ulasan)
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 dalam 1 hari
(3 Ulasan)
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 Lebih banyak

$205 AUD dalam 3 hari
(0 Ulasan)
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 Lebih banyak

$140 AUD dalam 4 hari
(0 Ulasan)
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 Lebih banyak

$190 AUD dalam 5 hari
(0 Ulasan)
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.) Lebih banyak

$140 AUD dalam 30 hari
(0 Ulasan)
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 Lebih banyak

$250 AUD dalam 5 hari
(0 Ulasan)
0.0
$167 AUD dalam 8 hari
(1 Ulasan)
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 dalam 3 hari
(0 Ulasan)
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 Lebih banyak

$140 AUD dalam 5 hari
(0 Ulasan)
0.0