Categorize some data in MS Access VBA program

If you know VBA, MS Access 2016 then this is easy for you!

1. Import: Form to import data from a csv file and puts it in a temp table. Data is always in same format.

2. a) Categorize: The data from 1 above in one of the fields contains a bit of string that you need to use to categorize it.

b) Categorize 2: form shows you the data record by record and tries to match it with the same text in a category table (category table would only contain a substring of the string in the data table).

c) If matched, the program adds all the values in the matching row from category table to the data and puts that new data in a "review" table. The original data gets appended to a "processed" data table

d) if unmatched, the program asks the user to categorize it with the option to remember the categorization for future. The user is asked which part of the data string is to be used for categorization. Then this is added to the category table.

e) Review stage: when temp table is empty, the "review" table is shown just to double check. User can make any adjustments as necessary. Categories values in the category are all from drop downs boxes sourced from data tables. This could be a subform on a form - user is asked to hit ok when done, this action ***appends*** all data from review table to categorized table and closes the form.

e) Quality control: Once all the above is working, we can add the quality control stage - it won't add to the categorized table if a string made up of all the values concatenated together from import data matches anything else in the categorized database.

It will be the easiest if we just do each stage separately. Once verified we move to the next stage (import, categorize, review, quality control)

*** must be done in MS access 2016

*** you will be supplied with the category table and sample csv

Should only take around 3-4 hours to do this including testing.

Thanks for bidding!

Kemahiran: Excel, Microsoft Access, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: exists data table access vba, import data excel access vba, accesse data ms access search vb, microsoft access programming language, ms access code builder examples, ms access programming pdf, how to run vba code in access, ms access vba code examples, access 2016 vba tutorial, microsoft access tips and tricks pdf, ms access application development tutorial, convert ms access database program, convert ms access exe program, function inserting data ms access desktop application, import data ms access excel net, manage serial port ms access vba, merge data ms access ms projects, ms access stand program, ms access vba ado samples mssql, ms access vba code copy paste subform form

Tentang Majikan:
( 203 ulasan ) Mississauga, Canada

ID Projek: #23603397

Dianugerahkan kepada:


Hello! This will require a user interface with few forms and some of the VBA coding. I think you are right about the time required for this. Can you send a CSV file? Regards, Branislav Mihaljev

$185 CAD dalam 7 hari
(259 Ulasan)

18 pekerja bebas membida secara purata $119 untuk pekerjaan ini


Hello dear sir! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirL Lagi

$100 CAD dalam sehari
(185 Ulasan)

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 Lagi

$30 CAD dalam sehari
(116 Ulasan)

Hi, I'm an MS-Access / VBA expert, and have experience in data import and quality control routine development, and I would LOVE to do this job for you. I can complete and deliver the Access database with all requeste Lagi

$140 CAD dalam 7 hari
(45 Ulasan)

Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VBA. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f and see following screens for : " Lagi

$250 CAD dalam 2 hari
(55 Ulasan)

Hi I am interested in the project. I am an experienced MS Access application developer. I have developed many applications and have done many change requests here on freelancer. If interested in hiring me then please Lagi

$200 CAD dalam 7 hari
(88 Ulasan)

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Lagi

$180 CAD dalam 2 hari
(33 Ulasan)

Dear client. Thank you for posting task and I am real expert in VBA and data management. I can do it in a day. I have many experiences in C#, VBA ODBC data manage in early time, You can check my past work in my feedba Lagi

$110 CAD dalam sehari
(5 Ulasan)

I am a systems analyst with more than 7 years of experience in the management of Excel datasheets and Access databases in a multi-national company. Advanced level competence in data analisys for decision making and adv Lagi

$110 CAD dalam 3 hari
(2 Ulasan)

Hi, I am a Software Professional developing software in MS Access with VBA for last 22 years. I would like to develop the database using MS Access 2016 as per your requirements.

$100 CAD dalam 3 hari
(8 Ulasan)

I can provide a complete Access application which you can use to categorize the data coming from CSV file. As I see it, you do have some (string matching) rules already present in the category table but they are not co Lagi

$79 CAD dalam 2 hari
(1 Ulasan)

Hi I'm an Access VBA developer with over 20 years experience. Data manipulation, creating functions in vba is my strongest skill. I love challenges like this and as I say, something I'm really good at. Get in touch, Lagi

$140 CAD dalam 7 hari
(1 Ulasan)

***** MS Access Expert ***** Hello . I have read your job description carefully. I have full experience in MSAccess and excel macro and vba. If you give me a chance, I will deliver good result. I hope to discuss more Lagi

$100 CAD dalam sehari
(0 Ulasan)

HI i'm a native italian and i know Access 2016. If you send me the files i start immediatly the job. best regards

$100 CAD dalam 2 hari
(1 Ulasan)

I am ready for the following tasks: 1. Import: Form to import data from a csv file and puts it in a temp table. Data is always in same format. 2. a) Categorize: The data from 1 above in one of the fields contains a b Lagi

$100 CAD dalam sehari
(0 Ulasan)

Im going through your Project Details,we can do some sample before,first we can quick chat & discuss about it. Thanks ....

$30 CAD dalam 2 hari
(0 Ulasan)

Hi Friend, I can do this as I have done similar work before. I will not charge if the work is not up to the mark. Please send me the file and I can play around and no cost to you. Thanks

$140 CAD dalam 7 hari
(0 Ulasan)

Hello There, I have read your work requirement description. From the description it come to know about you have large csv files that you want categorized and want to create proper user friendly reports. I have create Lagi

$40 CAD dalam sehari
(1 Ulasan)