Data conversion multiple .dbf's to 1 .xls (some programming)
$250-750 USD
Closed
Posted almost 14 years ago
$250-750 USD
Paid on delivery
This is part of a data conversion project. I will provide 3 .dbf databases with 1,500 to 3,000 records each. One is a database of phone numbers with 1 record for each phone number. The phone database has an field that tells if the phone number is business, home, mobile, fax, etc. This descriptor field was populated from a dropdown list, not from user entry. The second database is addresses with a separate record for each address. The address database has a field that tells whether the address is home, business, etc. Again, this descriptor field was populated from a dropdown list, not from user entry. The third database is a notes database with a separate record for each note. The databases all have a field in common labeled SerialID that contains a unique number for each client. The end result is to be an .xls database that has column for serialid,workphone,homephone,vacationphone,mobilephone,faxphone,homestreet,homecity,homestate,homezip,workstreet,workcity,workstate,workzip,notes
So before there were multiple records for the same client in each database and now they are all on one row of the .xls database. The notes fields would all be combine into one notes field in the .xls database. This is not exactly all of the fields involved, but is close.
Simple Task. I've been doing this kind of merge for several years in the past.
Many years of Professional work give me the experience to execute this task.
See PMBox
Hi, I run a small software house in the UK. This kind of data conversion from xls / xml to DB tables and back is the backbone of what we do here. I can accomplish your requirements with the absolute minimum of fuss and in a good time.
I would like to work with you on this and look forward to hearing from you,
Mick
Hi. I can do this project in a few hours after receiving DBFs. Although, I will use Python for it (as it already has library for working with DBF databases) and I will be able to supply you with both program sources and XLS file file it produces.