Find Jobs
Hire Freelancers

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 ...
项目 ID: 2530366

关于此项目

22提案
远程项目
活跃11 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
22威客以平均价$187 USD来参与此工作竞价
用户头像
Please check PM. Thanks
$200 USD 在2天之内
4.9 (264条评论)
7.5
7.5
用户头像
Hi sir, please check PM, thx Kimi.
$190 USD 在5天之内
5.0 (139条评论)
6.9
6.9
用户头像
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 在2天之内
4.9 (167条评论)
6.9
6.9
用户头像
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 在4天之内
4.9 (98条评论)
6.5
6.5
用户头像
Hi, data conversion expert here. Please check my private message for an example converted data.
$550 USD 在14天之内
4.9 (59条评论)
6.2
6.2
用户头像
Hi, Plz see your PMB for important project information.
$60 USD 在2天之内
4.9 (33条评论)
5.6
5.6
用户头像
hire me!!..i can complete this task within 10 days..please provide me all 12 yrs excel files..Regards..Raj..!
$400 USD 在12天之内
5.0 (47条评论)
5.7
5.7
用户头像
Hi, I can do this job for you, Mira mi mensaje personal
$200 USD 在5天之内
4.9 (30条评论)
5.5
5.5
用户头像
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 在5天之内
4.8 (24条评论)
4.9
4.9
用户头像
Please see more details with sample Access database on PMB. Thanks
$200 USD 在5天之内
5.0 (27条评论)
4.5
4.5
用户头像
can develop script to update / create the access db from excel data.
$80 USD 在3天之内
5.0 (23条评论)
4.2
4.2
用户头像
We r macro expert having experience of more than 13 years
$100 USD 在1天之内
4.9 (15条评论)
3.8
3.8
用户头像
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!
$200 USD 在5天之内
5.0 (5条评论)
3.8
3.8
用户头像
Please check the PMB...Thx
$75 USD 在5天之内
4.8 (10条评论)
3.6
3.6
用户头像
Please few question on PMM. regards
$250 USD 在20天之内
3.8 (4条评论)
4.4
4.4
用户头像
I can do this for you..please share the files and DB details i am ready to start the work.
$125 USD 在5天之内
4.9 (3条评论)
1.8
1.8
用户头像
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 在7天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在15天之内
0.0 (0条评论)
0.0
0.0
用户头像
i m ready to work immediate
$230 USD 在5天之内
0.0 (0条评论)
0.0
0.0
用户头像
Access experienced
$79 USD 在4天之内
0.0 (0条评论)
0.0
0.0

关于客户

MEXICO的国旗
Mexico DF, Mexico
5.0
5
付款方式已验证
会员自8月 18, 2008起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。