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!
9 freelancer bu iş için ortalamada 27$ teklif veriyor
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.