Find Jobs
Hire Freelancers

Write Excel Report using SQL Server 2012 tables

$30-250 USD

Completed
Posted over 8 years ago

$30-250 USD

Paid on delivery
I am open to maybe someone with SQL database skills that can create Excel reports, or at least make the connections. Skills: MS Access, SQL Server 2012, Excel 2013, VBA, VBA Excel Reports Current State: Currently an Access database front end opens an Excel 2013 template. Then within Excel the vba points to Access database tables on our network drive. Then Excel sSql select statements are written to query the data from the Access tables and produce the report. What Is Needed From You: We have moved the Access database tables to SQL Server 2012 database. However, we still have the Access front end that will open the Excel 2013 report. Except now it should point to the SQL server tables and then use Excel sSQL select statements to query the data from SQL to produce the report. I am open to creating SQL views instead of writing the long select statements in Excel or connecting via ODBC, MS Query, etc. Whatever will open and render the report faster. The report has graphs, pie charts, and data tabs. The report is already created. I just need to point it to SQL server tables instead of Access database tables. I think I should mention that they may need to be some tweaking of SQL tables. I'm also getting and "Identity" PK error on a couple of SQL tables. Fix it today, get paid today. Let’s chat. Ben
Project ID: 9047312

About the project

27 proposals
Remote project
Active 8 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
Hi, I understand you are in a hurry, so, I propose you to do a first step so: There is a way to link yours old structure to the new ones tables, in order to keep the old reports as their are, pointing to access but with a connection to the data in SQL database. At the same time, we can develop what you want, quietly, not running. well done. I really think it is better not touch the actual reports. So, we can connect them to the new dabtabase using ODBC via ADO from VBA. To do this work, I will need: Whole permissions to get the structure and some data do copy in my computer(if not very confidential). both databases . Additinally, the excel programs... Please contact if you think I am your candidate..
$40 USD in 4 days
4.9 (59 reviews)
5.8
5.8
User Avatar
Hi Sir, I can done it in 2days at weekend. I have many reports at my company which access to SQL server Oracle from excel to generate the data. Thanks Thanh
$100 USD in 2 days
5.0 (43 reviews)
5.9
5.9
27 freelancers are bidding on average $157 USD for this job
User Avatar
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$147 USD in 3 days
4.7 (90 reviews)
7.3
7.3
User Avatar
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". Maybe you will find the similarity.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$246 USD in 5 days
4.7 (52 reviews)
6.1
6.1
User Avatar
I am an expert in delivering custom software and scripts willing to discuss further about the requirements asap
$200 USD in 3 days
5.0 (19 reviews)
5.4
5.4
User Avatar
I have developed numerous systems in Access (utilizing VBA). I have developed a wide range of systems from small systems used by non-profits to average size systems used by small/medium business as well as enterprise systems being used by a Fortune 50 company. I have all the necessary experience and feel that I would be a perfect fit for your project. I would be more than happy to discuss your project as well a go over my experience and demo some of the systems I have built or am building. I hope to hear from you. Background: I am a software developer with 12+ years experience. I am currently consulting for a Fortune 50 company doing work primarily in Access and Excel with VBA. I have extensive experience in other aspects of software development as well. I am employed full-time, for the last 5 years, doing .NET development. I have built several large enterprise solutions during this time. I am very knowledgable in the following: .NET, VB, C#, HTML, javascript/jQuery, SQL, Access, Excel, VBA, Flash, Actionscript, PHP. I am new to Freelancer but am trying to build a solid profile. If you would like to talk before awarding this project let me know. Hope to hear from you.
$161 USD in 5 days
4.2 (18 reviews)
5.8
5.8
User Avatar
We are SQL Server professional and can deliver within less time, so please let us know if we can help you.
$172 USD in 2 days
4.2 (12 reviews)
4.3
4.3
User Avatar
A proposal has not yet been provided
$300 USD in 5 days
5.0 (3 reviews)
3.1
3.1
User Avatar
Hi, I can help you with you request, I've a lot of experience with MS SQL. How is the SQL security defined for the front end application? Are you using integrated or SQL security? About the Identity problem, we need to check wich primary key is being effected and why, it seem that exists a duplicated value. Regards.
$222 USD in 1 day
5.0 (2 reviews)
2.6
2.6
User Avatar
Hello, I have time today to finish, pm please
$40 USD in 1 day
4.6 (1 review)
2.1
2.1
User Avatar
A proposal has not yet been provided
$111 USD in 3 days
5.0 (1 review)
1.5
1.5
User Avatar
My objective is to satisfy customers by accomplishing their requirement with quality service, on time delivery and at low cost. We have a sme who can complete your requirement within 2 working days. Please find below the skill set of my sme. Please mail us / call us any queries in this regard. 5+years of experience as specialized in Microsoft SQL SERVER Development and MSBI (SSIS & SSRS)Tools. Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler and Execution Plan. Experience on working with database like SQL SERVER 2008 & SQL Server 2012. Good knowledge on Sub queries, Joins, set operations and stored procedures. Sound knowledge in Database Backups and Restore process. Hands on experience in Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS). Working on Creation of SSIS Packages using Control flow, Data flow and tasks in order to achieve business requirements. Hands of experience in creating SQL Server Agent Jobs and SSIS Packages. Well versed in analyzing the client production issues and resolving. Thorough Knowledge on Data Warehouse concepts like Star Schema, Dimension and Fact Tables. Worked as a Sr. SQL Server Database programmer on MSBI Tools. Technical Proficiency: ETL Tool : SSIS Reporting Tool : SSRS Operating Systems: Windows 2003/XP. Database : SQL Server 2008/2012.
$166 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, My name is Kaustubh. After carefully reviewing the experience requirements of the job description, I have excellent experience in web research, SEO, data entry; Ms excel, Ms Word, Ms PowerPoint, article writing, forum posting, link building, blog commenting, directory submission, social bookmarking and more other experience. I have excellent communication skills and English. I also enjoy typing and researching websites. I am available at any time during the week. Best Regards, Kaustubh
$55 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$198 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello.. my proposal is to upsize the access db.. doing that.. all processes will be executed by access engine and you will still be able to see data in both sql and access.. in other words.. sql server will be just a data repository and access will contain links to the sql database.
$189 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Let's chat.
$150 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Pls share the detail of the existing system and we will discuss abt that and provide a better solution and report generation tool for ur reporting in excel format.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$222 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have around 8+ years of I.T. Currently i am working as a Microsoft Business Intelligence Technical Lead. I have worked on SSIS, SSAS, SSRS, BIRST, Tableau, Datazen and have in-depth understanding of SQL Server and usually do Query optimization and implementing complex logic in SQL. I feel certain that my strong technical skills coupled with my ability to deliver thing quickly will be of immediate value to this project. I very much hope that you will look favourably upon my application by recognizing my enthusiasm, talents in the field of MSBI and my future potential. I would dearly like to further discuss the scope of this project, with you over the call, and would welcome the chance of a meeting over skypee.
$166 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I'm Bhaskar MSc Computer Science from Andhra University , Andhrapradesh , India. Oracle Certified Associate . Oracle Certified Professional . Web Designing Expert. Worked as Database Team lead in Gulf 9 years present I'm running Startup Company 'Ram Info' since 2years with 10 member S/W Engineers working with me . plz cooperate out team . thank you Bhaskar +91-9542438885
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Comes from a Consulting background and been in IT for over 6+ years. Can help you with this activity of yours.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Pleasanton, United States
5.0
46
Payment method verified
Member since Feb 10, 2014

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.