Script Cron - Access to MySQL

This project received 45 bids from talented freelancers with an average bid price of $127 USD.

Get free quotes for a project like this
Project Budget
Total Bids
Project Description


I need to have an access script or any script that could take the data of 1 mdb file into SQL or CSV.

There is 30 fields to transfer. Most of them are as it is and

Field to convert:

"Name" need to combine 3 fields from mdb (First Name "Space" Last Name "Space" Provider)

"Country" blank field must be replaced by "Switzerland"

"Customer No" must be converted with no spaces

"Option" must be converted as this exemple: "01" = "Full Pack" - "02" = "Medium Pack" - "A1" = "Small pack" - "1B" = "Minimum Pack"

"Contract Date" must be converted into Unix timestamp

"Amount" must be converted without the ".-" sign

"Hardware" must be converted as this exemple: "04" = "Full Equipment" - "05" = "Medium Equipment" - "A2" = "Small Equipment" - "2B" = "Minimum Equipment"

"Exp Date" must be converted from dd/mm/aaaa to mm/aa

"Card" must convert only the 4 last digits

"CardType" must convert card that start by 4 as "Visa" and 5 by "Mastercard"

"DDSort" must convert last 2 digits

"DD Account" must convert last 2 digits

Full description will be giving away one project accepted.

This needs to be setup as Cron so I can upload the database manually or automaticly from a Windows environnement to a remote MySQL server. (Which ever is the most practical)

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online