Data Conversion/Visual Basic Macro

Completado Publicado Dec 1, 2009 Pagado a la entrega
Completado 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

Procesamiento de datos Microsoft Access Visual Basic

Nº del proyecto: #562270

Sobre el proyecto

42 propuestas Proyecto remoto Activo Dec 3, 2009

Adjudicado a:

djucuti

Hello, please check PM!

$50 USD en 2 días
(30 comentarios)
5.1

42 freelancers están ofertando un promedio de $65 por este trabajo

HussienSharaf

HI, i can make the required code in 2 hours. I m the best VBA expert. Hussien Sharaf

$35 USD en 1 día
(63 comentarios)
6.7
tootwotrue

Please see PMB for details. Tks, Drew

$65 USD en 1 día
(9 comentarios)
5.6
piyushdpatel

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

$70 USD en 2 días
(24 comentarios)
5.1
dipak123

Please check inbox for more details.

$30 USD en 5 días
(20 comentarios)
4.8
nmppatel

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.

$90 USD en 2 días
(24 comentarios)
4.8
KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

$30 USD en 0 días
(38 comentarios)
5.0
agihcam

Please check PMB.

$50 USD en 1 día
(18 comentarios)
4.5
oFAZo

Exceptional quality & Quick work. Please refer to Profile & PMB for details. Thanks FAZ

$40 USD en 0 días
(16 comentarios)
4.3
frehmanpk

Respected Sir, Very Simple Task. I have done 5 small business projects in MS Access. Inventory & Stock Management System, Accounts, HRMS and Sales Management System. I can start with you right now. I assure to quality Más

$100 USD en 2 días
(16 comentarios)
4.5
johnsinit

Dear WebZPlus! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

$68 USD en 2 días
(15 comentarios)
4.2
muhmuuh

Hello! Please check PM for details. Thanks

$30 USD en 1 día
(20 comentarios)
4.2
dataconversion1

Dear Sir, Please check PM for details. Thanks.

$30 USD en 0 días
(4 comentarios)
2.9
snitchell

I'm a british process engineer, and have recently been involved with simalar projects. I can provide 3 solutions... 1) a VBA macro - run in access, to extract the data. 2) a windows application - you'd select the excel Más

$100 USD en 2 días
(1 comentario)
2.6
brunolau

Hi, I can create you a Windows application that would do the desired task

$70 USD en 2 días
(1 comentario)
2.8
uongthiduc

I'm ready to do it now.

$100 USD en 5 días
(0 comentarios)
0.0
darthobra

Dear Sir or Madam, I have written data processing routines that perform this very type of conversion. After reviewing your data I am sure that I can quickly convert the majority of your data with little to no problem Más

$75 USD en 2 días
(0 comentarios)
0.0
Santhosemscss

i like to do

$30 USD en 10 días
(0 comentarios)
0.0
rjancoski

I have experience doing data manipluation between Excel and Access using VBA. Pleass give me a try!

$75 USD en 2 días
(0 comentarios)
0.0
softouchvision

Sir, we are intrested this job

$228 USD en 5 días
(0 comentarios)
0.0
lchwzh

Hi,I can do it.

$30 USD en 3 días
(0 comentarios)
0.0