Convert data from multiple structured excel files into a database (access)
$30-250 USD
Płatność przy odbiorze
We have 400 excel files per year * 12 years = more than 4 000 formated excel files to extract data from them and write in access records. The access table should have specific fields: excel file name, year, excel file title, excel row, excel column, amount. We need to convert those more than 4000 excel files into one single access table. Attached you have examples of the excel files. Example:
Excel name CUADRO 1 1 AÑO 2010 - first rows:
1. 1 POBLACION AMPARADA POR ENTIDAD FEDERATIVA
FAMILIARES DE
DELEGACION TOTAL TRABAJADORES FAMILIARES PENSIONISTAS PENSIONISTAS
T O T A L N A C I O N A L 11,993,354 2,644,359 7,679,514 806,781 862,700
DISTRITO FEDERAL 3,248,051 720,042 2,072,202 245,221 210,586
ZONA NORTE 764,944 169,574 488,024 57,755 49,591
ZONA ORIENTE 789,270 174,967 503,536 59,590 51,177
ZONA SUR 1,116,335 247,475 712,206 84,279 72,375
The result for this example should be those records in the MS access table:
Record 1- fields:
Excel name - CUADRO 1 1 AÑO 2010
Title - 1. 1 POBLACION AMPARADA POR ENTIDAD FEDERATIVA
Row - T O T A L N A C I O N A L
Column - Total
Amount - 11,993,354
Record 2- fields:
Excel name - CUADRO 1 1 AÑO 2010
Title - 1. 1 POBLACION AMPARADA POR ENTIDAD FEDERATIVA
Row - T O T A L N A C I O N A L
Column - Familiares de Trabajadores
Amount - 2,644,359
Record 3- fields:
Excel name - CUADRO 1 1 AÑO 2010
Title - 1. 1 POBLACION AMPARADA POR ENTIDAD FEDERATIVA
Row - T O T A L N A C I O N A L
Column - Familiares
Amount - 7,679,514
...
Numer ID Projektu: #2530366
O projekcie
22 freelancerów złożyło ofertę za $187 w tym projekcie
Excel and Access VBA expert here - will provide you with a working db in a couple of hours for review - thanks in advance - Rajiv
Hi.. Expert database developer here. Assure you accurate database according to your requirements. My bid is for exact database. Ready to start. Have a look at PM. Regards
Hi, data conversion expert here. Please check my private message for an example converted data.
hire me!!..i can complete this task within 10 days..please provide me all 12 yrs excel files..Regards..Raj..!
hi, I can do it. I'm programmer for years and very familiar with VBA for Excel automation and data processing. What access version do you use? Best regards, Cuong NH
I can do this for you..please share the files and DB details i am ready to start the work.
The best olution for your work is a utility which automatically convert your data from excel to access. It will be a installer . We can develop and customize it according you . Also we will give support .
Team, I have good knowledge of .NET technologies and can convert your excel files in access database. Kindly consider my bid for this project.