Find Jobs
Hire Freelancers

spreadsheet transfer from Excel to Access with VBA

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
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
Project ID: 17636056

About the project

1 proposal
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 3 days
4.9 (172 reviews)
6.5
6.5

About the client

Flag of UNITED STATES
United States
0.0
0
Payment method verified
Member since Aug 24, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.