Hi!
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)
MS Access expert here. We can create the script in MS Access. Probably have a single and an export button to export the data into a CSV file. I have done a lot of MS Access projects here in freelance. Please see my profile for more details. Thanks you.
Hi pyrophoenix lets do it. i can make a php script that when you upload a file on server it will convert to sql. Please check my profile. Thank you and good luck