Access to Excel Data mapping Macros

进行中 已发布的 Jan 15, 2015 货到付款
进行中 货到付款

We need this job done in the next two days...

Please do not bid if you cant do it.

We need to write a macros to map contact data from an access file to excel. We will provide the excel layout.

Additionally we will need to number the contacts

There is 40 columns and some columns allow additional rows for addiotional data

Below is a list, I've attached the sample excel sheet

Salutation

First Name

Last Name

Hebrew Name

Birthday Hebrew

Birthday

Main Email

Company

Name

Special Date1 (additional rows)

Special Date1 type (additional rows)

Special (additional rows)

Email (additional rows)

Email Type (additional rows)

Phone Number (additional rows)

Phone Number type (additional rows)

Address (additional rows)

Address type (additional rows)

Spouse (additional rows)

Spouse Type (additional rows)

Spouse Birthday (additional rows)

Spouse Hebrew Birthday (additional rows)

Spouse Address Type (additional rows)

Spouse Address (additional rows)

Spouse Email Type (additional rows)

Spouse Email (additional rows)

Spouse Phone Number Type (additional rows)

Spouse Phone (additional rows)

Child (additional rows)

Child Type (additional rows)

Child Birthday (additional rows)

Child Hebrew Birthday (additional rows)

Child Emergency Contact (additional rows)

Child Allergic (additional rows)

events (additional rows)

programs (additional rows)

groups (additional rows)

Billing Item (additional rows)

Amount (additional rows)

Date Added (additional rows)

Billing Type (additional rows)

数据库管理 数据库编程 Excel 微软Access

项目ID: #6980746

关于项目

27个方案 远程项目 活跃的Jan 16, 2015

有27名威客正在参与此工作的竞标,均价$145/小时

zExcel

A proposal has not yet been provided

$200 USD 在2天内
(256条评论)
7.7
fabest

Dear, I am Access/Excel expert since 11 years. I checked your project description, and I confirm I can map your contact to Excel. As you can see I have very good rate, you can be sure I am serious. Regards, Fabri 更多

$144USD 在1天里
(88条评论)
7.3
maverick44000

Hi. I have done several projects which require mapping data from Access to Excel or vice versa. I am sure that I can do the job for you in 1 day. I am also ready to start working without any milestone in advance. Can y 更多

$160USD 在1天里
(72条评论)
6.8
avinav606lx

Hey There, Thanks for posting the project. It looks feasible and I am interested to get it done for you. Next steps: Lets discuss/validate the complete requirement and effort and I can start to get this don 更多

$178 USD 在2天内
(182条评论)
6.6
hieutc

Hi, I have a question regarding your requirement: By "addtional rows" you mean that if there are more than one record in the access file then the excel file will need to add one (or more) row for the record, but if 更多

$100USD 在1天里
(15条评论)
6.2
vikas0903

Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on designing, implementing and analyzing ACBC (conjoint) surveys, pricing models, income statements, business analysis etc. Prior that 更多

$155USD 在1天里
(38条评论)
5.6
MarlinSoftware

Hi, this would be better achieved with a VBA function. Because you have supplied a .CSV, is the database in .MDB format (Access 2000 - 2003) NOTE: The function would require Access to be installed on the machine 更多

$175 USD 在2天内
(23条评论)
5.5
tasleem83

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start and finish it FAST. (tasleemnaz 更多

$100 USD 在2天内
(90条评论)
5.3
jeanek

Good Day, I would like to express my interest in your project. I am a holder of a BSc. (Hons) Computing degree from the University of Greenwich (UK) and have over 8 years professional work experience in the IT i 更多

$175 USD 在2天内
(6条评论)
5.0
ahmedsobherfan

A proposal has not yet been provided

$125 USD 在2天内
(27条评论)
4.1
milanmartinjuk

Hi, Your project sounds very interesting and simple enough and I believe that I'll be able to perform the task perfectly. As for my experience, you can see for yourself that I've worked here mainly as a content a 更多

$131 USD 在2天内
(21条评论)
4.1
bubu77

Hi, Microsoft Technology expert having 8+ years of IT experience and doing freelancing. I have gone through your requirement and will be able to do the job for you within 2 days. Need few clarifications... 1. Do yo 更多

$111 USD 在2天内
(11条评论)
4.0
ENRICOJ

HI . I WOULD BE HAPPY TO HELP . YOUR SOLUTION IS WHAT IS CALLED ----E T L---- EXTRACT TRANSFORM AND LOAD. A GOOD WAY TO DO IS ,WHEN I RECEIVE THE FILES I CAN CLEAN IT UP FOR YOU AND LOAD IT IN A PROPER F 更多

$244USD 在1天里
(11条评论)
3.4
EgyProgramer

A proposal has not yet been provided

$90 USD 在2天内
(9条评论)
3.4
swarm22

Dear Sir, I have +5 year experiences in MS Access Development. To Provide Quality,Well Documented , Modular and Object Oriented Work. Thanks & Regards

$111 USD 在2天内
(15条评论)
3.0
abdoDotNet

hello,, i am a senior .Net Developer, i have 8 years experience in fields like (GIS solution, ERP, GPS Track, Mobile Applications, Embedded systems, Socket programming,..)

$100 USD 在0天内
(0条评论)
0.0
Az507

It's only just about bidding, it's about who can really work. I can do your work cause I can complete your work in limited time. Special thanks (IF) on selecting me.

$155 USD 在3天内
(0条评论)
0.0
sanjeewa951

HELLO SIR I CAN DO YOUR PROJECT THANK YOU I TAKE IT YOU FOUR DAYS SO I THINK YOU SEND ME YOUR PROJECT THANK YOU

$55 USD 在4天内
(0条评论)
0.0
typingexpert78

I feel my skills and capabilities are a good fit to this position. It would be my pleasure to work as Data Entry Operator. I am a strong candidate for this job because I have 6 years of extensive experience as a dat 更多

$35 USD 在0天内
(1条评论)
0.0
golf1234john

To whom it may concern I am writing to express my interest in the Financial position that is currently available with your organization. With over 20 years of experience in Accounting & Financial Management, including 更多

$155 USD 在2天内
(0条评论)
0.0