Convert data from multiple structured excel files into a database (access)

W Toku Opublikowano Oct 1, 2012 Płatność przy odbiorze
W Toku 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

...

Excel Microsoft Access

Numer ID Projektu: #2530366

O projekcie

22 ofert Zdalny projekt Aktywny Oct 2, 2012

22 freelancerów złożyło ofertę za $187 w tym projekcie

bouslimi1979

Please check PM. Thanks

$200 USD w ciągu 2 dni
(264 Oceny)
7.5
mantislin

Hi sir, please check PM, thx Kimi.

$190 USD w ciągu 5 dni
(139 Oceny)
6.9
torajiv

Excel and Access VBA expert here - will provide you with a working db in a couple of hours for review - thanks in advance - Rajiv

$100 USD w ciągu 2 dni
(167 Oceny)
6.9
uumairkhalid

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

$40 USD w ciągu 4 dni
(98 Oceny)
6.5
fareastern

Hi, data conversion expert here. Please check my private message for an example converted data.

$550 USD w ciągu 14 dni
(59 Oceny)
6.2
pkcyber

Hi, Plz see your PMB for important project information.

$60 USD w ciągu 2 dni
(33 Oceny)
5.6
RajHeartbeat

hire me!!..i can complete this task within 10 days..please provide me all 12 yrs excel files..Regards..Raj..!

$400 USD w ciągu 12 dni
(47 Oceny)
5.7
diegogarcia0531

Hi, I can do this job for you, Mira mi mensaje personal

$200 USD w ciągu 5 dni
(30 Oceny)
5.5
Nhcuong

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

$185 USD w ciągu 5 dni
(24 Oceny)
4.9
hemi

Please see more details with sample Access database on PMB. Thanks

$200 USD w ciągu 5 dni
(27 Oceny)
4.5
vnb400sl

can develop script to update / create the access db from excel data.

$80 USD w ciągu 3 dni
(23 Oceny)
4.2
vikashgadia

We r macro expert having experience of more than 13 years

$100 USD w ciągu 1 dnia
(15 Oceny)
3.8
MattyM01

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. Więcej

$200 USD w ciągu 5 dni
(5 Oceny)
3.8
ummednegi

Please check the PMB...Thx

$75 USD w ciągu 5 dni
(10 Oceny)
3.6
ExactSystems

Please few question on PMM. regards

$250 USD w ciągu 20 dni
(4 Oceny)
4.4
sureshoragadam

I can do this for you..please share the files and DB details i am ready to start the work.

$125 USD w ciągu 5 dni
(3 Oceny)
1.8
yadavsatyam2

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 .

$190 USD w ciągu 7 dni
(0 Oceny)
0.0
topgear2912

Team, I have good knowledge of .NET technologies and can convert your excel files in access database. Kindly consider my bid for this project.

$250 USD w ciągu 15 dni
(0 Oceny)
0.0
Alld

i m ready to work immediate

$230 USD w ciągu 5 dni
(0 Oceny)
0.0
OnlyOne2010

Access experienced

$79 USD w ciągu 4 dni
(0 Oceny)
0.0