Data Conversion/Visual Basic Macro
$30-250 USD
Pagado a la entrega
Hello and Thank You for looking at our project - Our Project will be a very simple task for the right person, we have customer address records (in Excel) that we need to perform some simple conversion on, the records only have four fields Company, Address, Telephone and Category, the address field contains the complete address which includes Suburb (City) State and Postcode (Postal Code) and the telephone field has a non numerical prefix that we need to discard.
So the project has two simple parts to it -
1. Seperate the elements of the address into address,suburb,state & postcode
2. Drop the prefix off the telephone field
I have created a simple Access Database (attached) that contains a saved import/export, data import and data output tables and tables containing the suburb, street abbreviations and postcodes - We need someone to write the macro that converts the data input table to the data output table.
If you look at the sample database attached I think it will be quite easy for you to understand what we require. Any errors or data that cannot be matched can remain in the address field of the output table.
Thank You and Good Luck
Nº del proyecto: #562270
Sobre el proyecto
Adjudicado a:
42 freelancers están ofertando un promedio de $65 por este trabajo
Hi This is Piyush Patel I have 5 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM
I am VBA Ms-Access expert. I have very good experince with VBA Macros with Ms-Access 2007. I have completed many project on GAF in VBA & Ms-Access skill. I will provide quick & professional service.
Dear WebZPlus! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.
I have experience doing data manipluation between Excel and Access using VBA. Pleass give me a try!