Access VBA Module

Module required to split UK postcode (zip codes) as per attached spreadsheet. The table on left is an Access table. The yellow table on right will be the resulting query,

The module needs to b run to create a query as per the yellow table.

So the new row is created after each space and then at the end of the cell. Unless there is a space the group will remain together e.g. BD1-22,97-99

1 B, BB, BD1-22,97-99, BL, CH, CV, CW, DE, DN1-12,16-17,21-22,31-35,40-41,55, DY, EN6-8, GL1-4,7,14,16-20,50-56, HD, HR1,4,6-9, HX, L, LE, LN1,5-6, LS, LU, M, MK, NG, NN, OL, PE1-11,13-16,19,26-30,38,99, PR, S,SK, SN1-7,25-26, ST, SY1-4,99, TF, WA, WF, WN,

The project needs to be uploaded in Access.

Skills: Database Programming, Excel, Microsoft Access, Visual Basic, Visual Basic for Apps

See more: how to call a module in access, ms access modules collection, ms access module example, ms access vba module, creating modules in access, access vba open module, how to create a module in access 2010, what is a module in access, access vba work required, access vba convert currency, input form access vba, access vba printer settings dialog, access vba create pdf, access vba outlook automation, processor access vba code, print pdf access vba, excel vba module, convert sql access vba, converting access vba, copy subform access vba

About the Employer:
( 6 reviews ) Alrewas, United Kingdom

Project ID: #17199041

Awarded to:


Hello! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 rep More

£20 GBP in 1 day
(81 Reviews)

13 freelancers are bidding on average £23 for this job


Dear Sir, I'm expert at access and ready to help you on doing your requirements. Kind Regards, NourElDeen

£20 GBP in 2 days
(60 Reviews)

I read your description and saw your attachment. I have years of experience in MS Access development, i am sure i can handle your request

£18 GBP in 1 day
(8 Reviews)
£18 GBP in 1 day
(7 Reviews)
£50 GBP in 10 days
(3 Reviews)

I have been working in the Analytics field for 2 years and also completed my MBA from a very reputed MBA college. This has helped me have a lot of experience in the field of analytics. Currently I am working on utilizi More

£18 GBP in 1 day
(11 Reviews)
£55 GBP in 1 day
(4 Reviews)

Hi, I will be able to get a working macro as per your requirement within a day if you can kindly allocate the project to me. Thank you.

£13 GBP in 1 day
(6 Reviews)
£18 GBP in 1 day
(3 Reviews)

Hi I am fast typist. I have a good time management skill. I have many years of work experiences in data entry. I have a very good knowledge of microsoft word. I will try to do your project as soon as possible. Best More

£19 GBP in 2 days
(0 Reviews)
£10 GBP in 1 day
(1 Review)
£18 GBP in 1 day
(0 Reviews)

I have knowledge in email & excel and macro. I will try to complete this task as per your requirement. Relevant Skills and Experience Excel macro and vb

£18 GBP in 1 day
(0 Reviews)