Sedang Disiapkan

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

...

Kemahiran: Excel, Microsoft Access

Lihat lebih lanjut: ms access 2010, 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

Tentang Majikan:
( 5 ulasan ) Mexico DF, Mexico

ID Projek: #2530366

23 pekerja bebas membida secara purata $189 untuk pekerjaan ini

fareastern

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

$550 USD dalam 14 hari
(48 Ulasan)
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 dalam 2 hari
(70 Ulasan)
5.6
mantislin

Hi sir, please check PM, thx Kimi.

$190 USD dalam 5 hari
(32 Ulasan)
5.6
bouslimi1979

Please check PM. Thanks

$200 USD dalam 2 hari
(31 Ulasan)
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 dalam 12 hari
(25 Ulasan)
5.2
pkcyber

Hi, Plz see your PMB for important project information.

$60 USD dalam 2 hari
(18 Ulasan)
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 dalam 4 hari
(16 Ulasan)
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 dalam 5 hari
(23 Ulasan)
4.9
diegogarcia0531

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

$200 USD dalam 5 hari
(18 Ulasan)
4.8
winnet21

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

$150 USD dalam 5 hari
(9 Ulasan)
4.5
ExactSystems

Please few question on PMM. regards

$250 USD dalam 20 hari
(4 Ulasan)
4.5
vnb400sl

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

$80 USD dalam 3 hari
(22 Ulasan)
4.2
hemi

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

$200 USD dalam 5 hari
(12 Ulasan)
3.8
vikashgadia

We r macro expert having experience of more than 13 years

$100 USD dalam sehari
(15 Ulasan)
3.6
ummednegi

Please check the PMB...Thx

$75 USD dalam 5 hari
(10 Ulasan)
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 dalam 5 hari
(2 Ulasan)
1.5
OnlyOne2010

Access experienced

$79 USD dalam 4 hari
(0 Ulasan)
0.0
rbtapan

I CAN DO THE JOB

$250 USD dalam 7 hari
(0 Ulasan)
0.0
Alld

i m ready to work immediate

$230 USD dalam 5 hari
(0 Ulasan)
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 dalam 15 hari
(0 Ulasan)
0.0