(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.
이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 25명, 평균 입찰가: $202
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.
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.
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