Here at London Software Solutions we specialise in providing Microsoft Office based custom/bespoke VBA software solutions on a budget that solve your company's problems (whatever they are). With 8 years of solid VBA experience working for financial, healthcare and government institutions.
Read More »
Some examples of services we provide are:
Staff Training Solutions
Budget Tracking Systems
•You have a detailed plan of what you want to acheive and how it should be designed. You just need someone to program it for you.
Short for 'Extract Transform Load'. This software solves the following major problems encountered by all database owners/administrators/analysts on a regular basis (every import):
•Your database field names are different and/or are in a different order to your input file.
•Your database fields require a certain value selected from a validation (dropdown) list. But your input file contains many different values that are not in your databases' validation list. For example, your database accepts 'Male', 'Female' and 'Transgender'. But your input file contains M, m, male, Male, bloke, man, F, f, Female, female, woman, TG, trans, etc. This is especially useful when attempting to standardise a large amount of data from different sources (e.g. NHS ethnicity codes vary from area to area). Our software also 'remembers' what you have chosen so the next time you import it will automatically convert, for example, 'trans' in the input file to 'TG' in your output file.
•Your database address fields are for example 'House Number', 'Street Name', 'Area', 'Town', 'Country', 'Postcode1' and Postcode2'. But your input file is 'Address line 1', 'Address line 2', 'Address line 3', 'Address line 4', 'Full Postcode'.
•In your input file users have entered full addresses in the house number field (or other address field). Meaning certian...
Read More »