OK, as almost everyone who bid on my previous post for this project had issues or complained about the format of the data, I have cancelled the original project and reposted this new one.
PLEASE READ THE FOLLOWING VERY CAREFULLY:
There are two files contained in the attached zip archive ([url removed, login to view] and rwy with [url removed, login to view]). The format & structure of the MDB file CANNOT be modified, changed or saved as a diiferent (later) filetype - the source application relies on this being in it's current Jet 3.5 form. The only tab in the spreadsheet that you should use for data is the 'Corrected Airport Data' tab. This has all the data in the format needed to repopulate the MDB.
The existing records in the MDB file should be deleted, otherwise there will be duplicate (and incorrect) entries. You will see in the XLS file that each runway is on a separate row - these need consolidating in the MDB file so that there is only ONE entry per ICAO code, with all the runway data in the correct fields. Each runway may have slightly different latitude & longitude coordinates - use the coordinates for the first entry for each airport to populate the MDB.
This should be a very straightforward task now - there is no need to alter any of the source data, and all the data columns and formats should marry up with the fields in the MDB. Note that some airports have LOTS of runways (hence the reason for MDB fields allowing up to 10 runways).
So, all I am looking for is someone to take the data in the XLS file & repopulate the MDB file making sure that all the data goes in the right fields......simples!
Greetings, We are group of professionals working together. We are having experience of more than 10+ years in the field of Data mining, Data entry, Web scraping, MS-Access and Excel. Hope you will give us a chanc Daha Fazla
Bu iş için 9 freelancer ortalamada $27 teklif veriyor
This is my understanding: You have excel sheet and a access database. You want to copy records from excel and put it in access database table ?
Hi, I have read all your requirements and I can do this job very professionally and you will get Pro Quality [url removed, login to view] we will work until your 100% Satisfaction please visit my profile portfolio for my work. I just ha Daha Fazla
I do understand your Project and Ready to be a part of your Project. I have a Good skill in MS Word, Excel and fast in typing With No error. High responsible and hard worker. Looking forward to be your co-work.
Sir, Professionally I am an Accountant since 23 Years & working in Indian Industry. I am confident of TIMELY DELIVERY OF EXCEPTIONAL QUALITY. I hope a Positive Kind Consideration of the BID lying for decision Daha Fazla
Hello, I can help you with your problem, I can create a program that reads excel and will insert the data into MDB file. Thank you