In Progress

Expiry Date Renewal

We download a CVS file containing the direct debit payment details of our members. This file contains their unique ID (Field: Client Ref) and their last paid date (Field: Last Paid). We would like a program that will read the details from the CSV file and then find the matching member in the MDB file (using Table: Members Details and Field: DD REFERENCE NUMBER) and then using their unique code number in the MBD (Field: Member Code) find the corresponding record in another table in the same MDB file (Table: Membership Card Details) and update the members expiry date (Field: Expiry Date) with the last paid date from the CSV file adding on another month (i.e. if the members last paid date was 14/06/2013, then the expiry date would be set to 14/07/2013). If there is no entry in the last paid column on the CSV then no change is to be made to the member record. I have attached sample CSV and MDB file for reference.

Skills: Database Administration, Microsoft Access

See more: expiry date renewal, microsoft access administration, mdb csv code, client payment details access database, member card file, membership access mdb, access sample program, mdb table csv, microsoft access sample program, access 2013 mdb, membership access database, month payment database, mdb file csv, read file table access, database month payment, access read file table, access mdb file, database sample program access, csv mdb access, code sample card payment, database csv mdb, mdb csv file, csv file download code, paid month access, cvs file

About the Employer:
( 7 reviews ) Cardiff, United Kingdom

Project ID: #4690874

Awarded to:

iamsameer

Please check your PM.

£50 GBP in 1 day
(0 Reviews)
0.0

31 freelancers are bidding on average £85 for this job

illuminesoft

I was trying to get the CSV file you mentioned, but the attachment was not there. We are amongst top 1% global outsourcing providers. We have successfully finished over 430 projects in last 13 years.

£150 GBP in 3 days
(242 Reviews)
7.4
rhomeu

MS Access expert here and I can help you with your project. I have done a lot of MS Access projects here in freelancer. Please see my profile for more details. Thank you.

£111 GBP in 1 day
(46 Reviews)
6.7
MarlinSoftware

Hi, I am a developer with over 22 years experience building complex database systems, specialising in the development of applications in MS Access using VBA and WinAPI. I could do this project to your specification wit More

£100 GBP in 2 days
(13 Reviews)
4.9
expertcoder1vw

I'm an Access and SQL expert. I can start work now, and deliver within 2 hours. Regards, Larry

£31 GBP in 1 day
(14 Reviews)
4.8
jhcannon

I have over 20 years experience with MS Access and have done countless data import and correlation routines similar to your request. I am available to start on the project now and will complete within 24 hours. I l More

£100 GBP in 1 day
(12 Reviews)
4.4
DenisSmolentsev

Hello! I have required experience. I will help you on that project with interest and pleasure.

£150 GBP in 5 days
(27 Reviews)
4.2
NourElDeen

Dear Sir, I'd like to help. Kind Regards, NourElDeen

£55 GBP in 3 days
(21 Reviews)
4.2
davidgraf

I literally have several decades of experience working with, developing and supporting relational database applications including products like Microsoft's Access and SQL Server. In fact, I helped develop systems for s More

£52 GBP in 0 days
(5 Reviews)
4.0
fabest

Dear, I am Access/VBA automation Expert since 10years. I can build Access tool to get automatically data from your CSV file, and process data to get results. Do you have example of this CSV file ? I will be availab More

£53 GBP in 1 day
(4 Reviews)
3.9
AmirAly

Greetings sir , check PMB please.

£23 GBP in 3 days
(7 Reviews)
3.5
parbit

Hello, it's so simple task for us and we can handle it. We will 1.develop your desired application from scratch for expiry date renewal 2.provide six months free support for the developed application. Please refer to More

£20 GBP in 0 days
(1 Review)
2.9
toxicman

Hello, Database wise is here. check p.m.

£52 GBP in 0 days
(1 Review)
2.8
pkcyber

Hi, Ready to Start Right Now. See my previous applications links on you tube for reference.

£44 GBP in 1 day
(2 Reviews)
2.5
gkan1234

Hi I am a professional Developer. I will do this for you.

£38 GBP in 3 days
(2 Reviews)
1.7
logu85

hi I just reviewed your Project Requirement, I can build the Function inside the Existing MDB itself to Import the CSV File and Compare the Member ID and Update the Expiry Details accordingly. please read the Client r More

£55 GBP in 3 days
(1 Review)
1.5
anomanpk

I would like to render my services for this job.

£150 GBP in 3 days
(1 Review)
1.3
veeru12

Hi, I am interested in this project. Quality work assured. Please see private message for details. Thanks

£100 GBP in 2 days
(1 Review)
0.8
yourofficeguru

I've worked with debit card processors, have 25 years experience software development and testing, and can give you what you want as part of the Access database that can be run on demand or scheduled.

£55 GBP in 3 days
(2 Reviews)
0.6
SidrahKanwal

Hi, Thanks for excellent explanation of work needed, though CSV sample is missing. It is real easy job for me. Looking forward to work with you. Regards, Sidrah Kanwal

£222 GBP in 3 days
(0 Reviews)
0.0
alphatech10

please check the pmb

£111 GBP in 5 days
(0 Reviews)
0.0