Devam Ediyor

Populate MDB file from XLS file

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!

Beceriler: Veri Girişi, Veri İşleme, Excel, Microsoft Access

Daha fazlasını görün: mdb files, looking for duplicate data in excel, data structure note, xls, slightly alter, populate, mdb, data longitude, read structure file, populate excel spreadsheet spreadsheet, excel modified, read file zip, duplicate file source code, populate excel spreadsheet, duplicate file, populate spreadsheet data, populate entry, excel spreadsheet structure, populate fields spreadsheet form, longitude latitude data entry, project populate, populate excel excel file, latitude longitude zip code, xls tab, longitude latitude excel

İşveren Hakkında:
( 64 değerlendirme ) London, United Kingdom

Proje NO: #6556566

Seçilen:

baseinformatics

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 fazlası

1 gün içinde 25$ USD
(10 Değerlendirme)
3.3

9 freelancer bu iş için ortalamada 27$ teklif veriyor

adityasl

A proposal has not yet been provided

1 gün içinde 17$ USD
(118 Değerlendirme)
5.2
LearningNew

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 ?

1 gün içinde 34$ USD
(7 Değerlendirme)
4.0
newhightech

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 fazlası

1 gün içinde 35$ USD
(2 Değerlendirme)
1.8
Leean84

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.

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
sargamaanand

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 fazlası

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
nitinbisht5

A proposal has not yet been provided

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
Nickydee

A proposal has not yet been provided

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
MariuSStar

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

in 3 gün içinde35$ USD
(0 Değerlendirme)
0.0