Expiry Date Renewal

In Progress

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:


Please check your PM.

£50 GBP in 1 day
(0 Reviews)

31 freelancers are bidding on average £85 for this job


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)

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)

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)

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)

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)

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

£150 GBP in 5 days
(27 Reviews)

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

£55 GBP in 3 days
(21 Reviews)

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)

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)

Greetings sir , check PMB please.

£23 GBP in 3 days
(7 Reviews)

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)

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

£52 GBP in 0 days
(1 Review)

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

£44 GBP in 1 day
(2 Reviews)

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

£38 GBP in 3 days
(2 Reviews)

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)

I would like to render my services for this job.

£150 GBP in 3 days
(1 Review)

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

£100 GBP in 2 days
(1 Review)

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)

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)

please check the pmb

£111 GBP in 5 days
(0 Reviews)