In Progress

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

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

...

Skills: Excel, Microsoft Access

See more: structured, norte, federal, data structured, excel convert access, 2010 access, multiple excel, excel access table, extract excel files, structured database, excel file convert, excel row column, excel record, excel column row, extract records, table extract, excel table 2010, write file excel, multiple fields, record excel, file name excel, column row excel, access 2010 convert, extract data excel files, access convert 2010

About the Employer:
( 5 reviews ) Mexico DF, Mexico

Project ID: #2530366

23 freelancers are bidding on average $189 for this job

fareastern

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

$550 USD in 14 days
(48 Reviews)
6.1
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 in 2 days
(70 Reviews)
5.6
mantislin

Hi sir, please check PM, thx Kimi.

$190 USD in 5 days
(32 Reviews)
5.6
bouslimi1979

Please check PM. Thanks

$200 USD in 2 days
(31 Reviews)
5.3
RajHeartbeat

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

$400 USD in 12 days
(25 Reviews)
5.2
pkcyber

Hi, Plz see your PMB for important project information.

$60 USD in 2 days
(18 Reviews)
5.1
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 in 4 days
(16 Reviews)
5.0
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 in 5 days
(23 Reviews)
4.9
diegogarcia0531

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

$200 USD in 5 days
(18 Reviews)
4.8
winnet21

Hi,I have experience with this project, Please check [url removed, login to view]

$150 USD in 5 days
(9 Reviews)
4.5
ExactSystems

Please few question on PMM. regards

$250 USD in 20 days
(4 Reviews)
4.5
vnb400sl

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

$80 USD in 3 days
(22 Reviews)
4.2
hemi

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

$200 USD in 5 days
(12 Reviews)
3.8
vikashgadia

We r macro expert having experience of more than 13 years

$100 USD in 1 day
(15 Reviews)
3.6
ummednegi

Please check the PMB...Thx

$75 USD in 5 days
(10 Reviews)
3.4
sureshoragadam

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

$125 USD in 5 days
(2 Reviews)
1.5
OnlyOne2010

Access experienced

$79 USD in 4 days
(0 Reviews)
0.0
rbtapan

I CAN DO THE JOB

$250 USD in 7 days
(0 Reviews)
0.0
Alld

i m ready to work immediate

$230 USD in 5 days
(0 Reviews)
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 in 15 days
(0 Reviews)
0.0