Excel VBA and SQL Server Specialist Needed for Multi-User Accounting System Setup
Worldwide
We are looking for an experienced Excel VBA and SQL Server specialist to help us configure, troubleshoot, and fully implement an existing Excel-based accounting system across multiple computers. The system is already developed and documented. We are not looking for someone to build it from scratch. We need a hands-on technical specialist who can review the current setup, resolve connectivity and synchronization issues, and ensure that the entire system works properly in a multi-user environment. System Technologies The accounting system currently uses: - Microsoft Excel - VBA Macros - SQL Server Express - SQL Server Management Studio (SSMS) - Power Query - Data Scripts - ODBC Driver - Multi-User Client-Server Architecture Project Goal The goal is to establish a reliable setup where: -One Server Computer hosts the SQL database. - Multiple Client Computers connect securely to the Server Computer. - Each department can access and use its assigned Excel forms. - Transactions entered from different computers are properly saved and synchronized. - Posted transactions are correctly reflected in the General Ledger. - Excel forms, macros, Power Query connections, and database workflows function consistently across all computers.
$5.00
Fixed-price- IntermediateExperience Level
- Remote Job
- Ongoing projectProject Type
Skills and Expertise
Activity on this job
- Proposals:5 to 10
- Interviewing:0
- Invites sent:0
- Unanswered invites:0
About the client
- PhilippinesCavite12:14 PM
- $1.1K total spent53 hires, 14 active
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by