Convert data from multiple structured excel files into a database (access)
$30-250 USD
Σε Εξέλιξη
Αναρτήθηκε πάνω από 11 χρόνια πριν
$30-250 USD
Πληρωμή κατά την παράδοση
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
...
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, 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
Hi,
I am an experienced developer in FileMaker Pro & Microsoft Access. I speciailze in creating custom databases for clients, ranging anything from Sales & Invoicing, CRM, Stock Management, and many other areas.
I have strong communication skills and a high attention to detail and can ensure working closely will give you a great result.
I hope to hear from you soon!
Cheers!
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 .