Find Jobs
Hire Freelancers

spreadsheet transfer from Excel to Access with VBA

$30-250 USD

已完成
已发布超过 5 年前

$30-250 USD

货到付款
I'm working on transferring spreadsheets from excel to Access. Each sheet from excel must correspond to each table in Access, and the sheet name in excel will be the table name in Access. I want to automate the process with VBA (either the code written within Access or Excel or both doesn't matter) . Automation is necessary since im dealing with multiple excel files, so I don't have to do import one table at a time, rather, just specify which file I need to transfer to or from, and click a button to get it done. There are examples of VBA codes online on this matter, I have tried coding some of them myself but isn't exactly working. I have attached the excel file with the worksheets for example. The tables that would be generated in Access need to look the same as in the worksheet. I would estimate $40 per hour of work, but no more than 4 hrs of work, so a lump sump of $160. Robust coding that is less prone to error, and with easy user interface is necessary and appreciated. Thanks, Pandu
项目 ID: 17636056

关于此项目

1条提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hello Pandu, This looks feasible. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A
$166 USD 在3天之内
4.9 (172条评论)
6.5
6.5

关于客户

UNITED STATES的国旗
United States
0.0
0
付款方式已验证
会员自8月 24, 2018起

客户认证

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