Compile data from multiple Access files into multiple excel files - 2

In Progress

Our project analyzes data regarding embassies for all countries since 1945.

The goal of this project will be to produce an application (in excel/access or desktop) to compile the data longitudinally (over years) for each country. The end result will be an excel workbook with approximately 340 sheets.

While the file system may seem cumbersome, the compile should be relatively straightforward. The file system for our project will consist of 67 access files (one for each year from 1945 to present), each containing approximately 340 tables (one for each country over these years). Each table records dyadic data on embassies.

We are currently in the middle of the data collection process which is being done in Excel and then converted to access. If an Excel based file system (with the same format as the Access one described above and below) is preferred to work with we are happy to discuss the possibilities.

Input (please see .mdb files and '[url removed, login to view]' in attached 'Inputs' folder for example)

1. The input Access (.mdb) files are of the following format:

---a. Each .mdb file represents one year

---b. Each .mdb file has around 340 tables (each representing one country)

---c. Each table has the following format:

------i. First column - Lists of all ~340 countries

------ii. Second column - Diplomatic Mission Code

------iii. Third Column - Focus

------iv. Fourth Column - Location

------v. Fifth through Ninth Columns - Leave and Entrance Dates

------d. The output will only concern itself with the first two columns (Country and Embassy).

2. There will also be a file which lists all countries and their birth and death years.

Output (please see ‘[url removed, login to view]’ for example)

1. The program should combine data for each year for a given country in a longitudinal spreadsheet (1945-2012). The name of the worksheet should be the country in question. The first column should have a list of all countries that the country in question has diplomatic relations with (i.e. any country that has a value in the "Embassy" column).

---a. The first row should have the years 1945 to 2012.

---b. Each subsequent row should copy the data for each country dyad for each year

------i. Remember: the name of the table in the input Access files becomes the name of the file of the output Excel file.

2. Code changes across years should be highlighted

---a. e.g. Embassy code in 2005 is 1, but in 2006 is 2

------i. Both cells should be highlighted

3. The Access files will be continually updated. When the code is run, only data found in the ‘Input’ folder should be found in the output

---a. e.g. If “Afghanistan, Pre Colonial” has no embassies in any of the .mdb files in the ‘Input’ folder, it should not have a tab in the ‘[url removed, login to view]’ file.

4. Years that are not found in the ‘Input’ folder should be grey in the ‘output’ file to indicate they are missing.

5. Data points that have an embassy attributed to a country for years either before they are “born” or after they are “dead” should be highlighted for that year.

---a. This pertains to both countries in the dyad.

---b. The country list and Birth/Death years will be continually updated

Skills: .NET, Data Processing, Excel, Microsoft Access, Visual Basic for Apps

See more: compile data access column year, excel compile multiple tables, compile excel file access, processing the data, mdb files, fifth third, multiple question, in process access, excel to access, excel based, compile, combine excel, being on mission, access v, access points, access d, code columns excel access, data excel work sheets, compile excel file, across multiple, multiple excel, excel access table, please worksheet attached, data collection excel spreadsheet, data collection spreadsheet

About the Employer:
( 55 reviews ) United States

Project ID: #4020306

Awarded to:


Hi, I can do the job, MS ACCESS expert, SQL, PL/SQL developer with several years of experience dealing with big and small databases Please check PMB Regards DIego

$160 USD in 5 days
(23 Reviews)

29 freelancers are bidding on average $154 for this job


Professional software developer with over 12 years experience. Please see PM.

$225 USD in 7 days
(29 Reviews)

Hello, please refer to your INBOX. Best Regards.

$400 USD in 7 days
(27 Reviews)

I will give u an exe for this purpose.

$95 USD in 3 days
(19 Reviews)

Dear jmoyer, I have something which may satisfy you...

$200 USD in 1 day
(26 Reviews)

ready to work

$200 USD in 10 days
(5 Reviews)

Hello Sir, I have 7+ years of experience in Software Development using .Net, C#, VB.Net, MSSQL,MySQL,MS Access, Visual FoxPro 9. I completed various Type of Project like. * Data Conversion * Code Protection * More

$120 USD in 10 days
(21 Reviews)

Top 1% in VB6 on Freelancer and lot of experience in this field, please check PM.

$140 USD in 7 days
(12 Reviews)

Dear Sir / Madam, We have more than 10 years of experience in IT Field and more over We have handled projects in various domains such as Trading, Manufacturing, Health care Management. I was associated with top c More

$200 USD in 10 days
(2 Reviews)

Hi , as we talked before im an experienced programmer for more than 8 years i can do it

$200 USD in 7 days
(7 Reviews)

Dear jmoyer, As I already described in my last bid for this project that I had sentyou an Excel file which extracts data from the Access files. Again see this Excel file in the PMB.

$100 USD in 4 days
(13 Reviews)

Hi, I have experience creating VBA macros for MS office applications. I would like to take up this project. The time line I have mentioned in the bid is conservative one that includes testing and minor modificatio More

$55 USD in 10 days
(7 Reviews)

Hello. I can help you with this project.

$200 USD in 10 days
(3 Reviews)

Greetings Client, I will be able to help you with your project request. I will provide you with a very robust and accurate project output. I have over 7 years of experience in Excel,Access VBA. I have developed and More

$175 USD in 7 days
(2 Reviews)

>>>>>>>>>>>>QUALITY HERE<<<<<<<<<<<<<<< +++++++++++++++please see my PMB++++++++++++++++++++

$30 USD in 7 days
(7 Reviews)

Hire the right one..

$135 USD in 5 days
(1 Review)

we will provide you complete Solution as per your need. For more detail please check our message where you can find our previous work too

$150 USD in 2 days
(0 Reviews)

Respected Sir, Having commerce background and 18 years experience as a foxpro programmer and 4 years as computer teacher and faculty. Now I have started 24*7 freelancing, So we can complete the project with spe More

$125 USD in 7 days
(0 Reviews)

We can go for a small executable program for this purpose, and can also have a entry level + reporting level for futuristic purpose. I want a bit more info regarding your project.

$32 USD in 7 days
(0 Reviews)

Hi, I am proficient in Access and Excel programming and MS access-Excel integration techniques. Have 5yrs of experience in this field. If the project is awarded to me I can finish it in 12 days (at present i am eng More

$110 USD in 12 days
(0 Reviews)

Hi!!, i'm very skiled in access and VBA application, and can do this job with no problems!!!

$190 USD in 10 days
(0 Reviews)