Find Jobs
Hire Freelancers

Create VBA code to refresh table links from MS-Access to SQL Server, Excel and Access

$30-250 NZD

Completed
Posted about 6 years ago

$30-250 NZD

Paid on delivery
Refer to attached zip file. The [login to view URL] file links to 2 Excel files, 1 Access file and 1 SQL Server database. The SQL database can be restored from the [login to view URL] file, then linked using ODBC, DSN name = 'Calendar' The [login to view URL] file has a local table (called 'Connection') which can be used to determine the paths of the files (or you can use your own schema for this) The objective is to change the file paths in the Connection table, then have the code refresh the links, with error messages where appropriate. For the SQl Server, the link may be to a different DSN name, server and database name, so it must take that into account.
Project ID: 16323584

About the project

4 proposals
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
Dear Sir, I'm expert at Access,Sql and excel and interested on doing your project, that was my last bid, how you give me the chance to work together. Kind regards,
$111 NZD in 1 day
5.0 (48 reviews)
5.5
5.5
4 freelancers are bidding on average $133 NZD for this job
User Avatar
Hi there,I am Miljan,IT expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Specializations and skills: Web Scraping(Python,PHP,node.js) Excel (VBA,Macros) Access,Word,Powerpoint Data Entry Data Processing Web Search Market Research Research Leads generating PDF to Excel WordPress Magento Shopify Data Base Programming HTML,CSS,PHP,JavaScript,jQuery,MySql Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me. There is a lot of experience behind me, so it will be a huge satisfaction for me to do this job. Feel free to contact me so we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Kind regards
$166 NZD in 2 days
5.0 (36 reviews)
5.9
5.9
User Avatar
Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines and budget accordingly. Thanks Regards Jawad
$155 NZD in 3 days
5.0 (78 reviews)
5.7
5.7
User Avatar
As a software developer I have the required know-how working with MS Access and VBA, I have even developed fully functional applications on this environment. I understand your goal. There would only be some little and specific points to discuss about the way the file paths are changed by the user and the complexity of the schema you expect (maybe this is a little part of some bigger project) I can guarantee you to get a final product of your total approval, as I will be glad of working on it. Hope to hear from you soon.
$100 NZD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NEW ZEALAND
Auckland, New Zealand
5.0
45
Payment method verified
Member since Jun 12, 2009

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.