Em Andamento

Data Conversion/Visual Basic Macro

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

Habilidades: Processamento de dados, Microsoft Access, Visual Basic

Ver mais: parts database access, easy conversion, access parts database, what data processing, customer database in excel, customer data in excel, Visual Basic Excel, simple macro, project includes two parts:, postcode, macro, macro excel, macro + excel, export data, excel visual basic, excel data input, data visual, Data tables, conversion\, sample data input, excel database visual basic, simple database visual basic, simple address database excel, access conversion, write macro

Acerca do Empregador:
( 23 comentários ) Bundoora, Australia

ID do Projeto: #562270

Premiar a:

djucuti

Hello, please check PM!

$50 USD em 2 dias
(28 Avaliações)
5.0

44 freelancers are bidding on average $64 for this job

HussienSharaf

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

$35 USD em 1 dia
(63 Comentários)
6.8
MAnkita

Hello,Please refer your [url removed, login to view] you.

$100 USD in 2 dias
(96 Comentários)
6.2
guoxinliu917

Hello, I can do it for you. Please check my PMB. Thanks.

$45 USD in 0 dias
(30 Comentários)
6.1
tootwotrue

Please see PMB for details. Tks, Drew

$65 USD em 1 dia
(9 Comentários)
5.6
KellogITSolution

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

$30 USD in 0 dias
(37 Comentários)
5.0
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 in 2 dias
(16 Comentários)
5.0
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 in 2 dias
(24 Comentários)
4.8
agihcam

Please check PMB.

$50 USD em 1 dia
(18 Comentários)
4.5
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 Mais

$100 USD in 2 dias
(15 Comentários)
4.4
oFAZo

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

$40 USD in 0 dias
(16 Comentários)
4.3
muhmuuh

Hello! Please check PM for details. Thanks

$30 USD em 1 dia
(20 Comentários)
4.2
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 in 2 dias
(14 Comentários)
4.2
dipak123

Please check inbox for more details.

$30 USD in 5 dias
(13 Comentários)
3.6
ExtraNet

Hi webZplus, I can write you that macro so that in a click of a button you will get your results. PM me if you're interested.

$80 USD in 3 dias
(8 Comentários)
3.4
dataconversion1

Dear Sir, Please check PM for details. Thanks.

$30 USD in 0 dias
(4 Comentários)
2.9
brunolau

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

$70 USD in 2 dias
(1 Comentário)
2.8
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 Mais

$100 USD in 2 dias
(1 Comentário)
2.6
rahulxlash

I have extensive experience with databases. I am very good with datamining . I am currrently working with a dataentry firm please give me chance to prove myself I am new to this site .I promise you great satisfactio Mais

$50 USD in 2 dias
(0 Comentários)
0.0
kosin

I am serbian programmer. 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 file / access file & table for import. or 3) a COM object - a Mais

$35 USD in 2 dias
(0 Comentários)
0.0
karankumar80

Hello Sir/Mam, I read your requirements and I can do this job perfectly, because I have good experience with Visual Basic Macro with Access database. So please contact me for further discussion on this project, Mais

$30 USD in 7 dias
(0 Comentários)
0.0