종료

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.

기술: 엑셀, 비쥬얼 베이직, 마이크로소프트 엑세스, 앱을 위한 비주얼 베이직, 데이터 처리

확대 보기: 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

고용주 소개:
( 2건의 리뷰 ) Sydney, Australia

프로젝트 ID: #25641675

이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 25명, 평균 입찰가: $202

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 더 보기

$110 AUD (1일 이내)
(203 리뷰)
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 더 보기

$336 AUD (7일 이내)
(58 리뷰)
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 (7일 이내)
(111 리뷰)
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 더 보기

$30 AUD (1일 이내)
(123 리뷰)
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 더 보기

$100 AUD (4일 이내)
(48 리뷰)
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 더 보기

$1000 AUD (7일 이내)
(9 리뷰)
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 더 보기

$140 AUD (7일 이내)
(15 리뷰)
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 더 보기

$200 AUD (7일 이내)
(3 리뷰)
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 (3일 이내)
(10 리뷰)
3.6
(2 리뷰)
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 더 보기

$250 AUD (7일 이내)
(11 리뷰)
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 (1일 이내)
(3 리뷰)
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 더 보기

$205 AUD (3일 이내)
(0 리뷰)
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 더 보기

$140 AUD (4일 이내)
(0 리뷰)
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 더 보기

$190 AUD (5일 이내)
(0 리뷰)
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.) 더 보기

$140 AUD (30일 이내)
(0 리뷰)
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 더 보기

$250 AUD (5일 이내)
(0 리뷰)
0.0
$167 AUD (8일 이내)
(1 리뷰)
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 (3일 이내)
(0 리뷰)
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 더 보기

$140 AUD (5일 이내)
(0 리뷰)
0.0