We need a Windows Form for an existing Windows Application that allow the user to import some data from Excel and OutLook.
After the user has chosen the file .xls (for outlook the user will export in Excel own contact list) the windows form shows a form split in two area: at the left will be the fields list found in the Excel file, at the right all the fields present in a MS ACCESS table (we provide you the table and the specs necessary).
The user could associate each field at the right with a field in the left. Not all the fields at the right should be selected.
Some database fields are related with other tables (we provide you the relationships between the tables), then when the user associates an field of the excel with a related field of the database the routine should be find in the related table the value and then save in the main table the primary key found.
If the value in the related table is not found the routine will create the new record and write the new primary key in the main table.
After the user have associated the fields he could start the import process.
A log file (for further errors) should be create during the process and if there are some errors a messagebox will alert the user and the error file is shown.
19 freelancers are bidding on average $146 for this job
i have 5 yrs exp in programming and have done the same thing for a very big client and the project is under production. i have done 3 projects which involved import , mapping of data
Sir/Madam I can surely help u in this. If necessery I can sent u the demo [url removed, login to view] u want me to do this work completey,please do mail me. Do send me the fields on left and right + relevant details