Find Jobs
Hire Freelancers

I need help converting SQL data (bak format) to an excel file of a member report (with payment details)

$750-1500 USD

Completed
Posted almost 6 years ago

$750-1500 USD

Paid on delivery
Attached are samples of reconciled reports for membership and conference that matched the GL amounts in Quickbooks. We need to create something similar with the .bak file attached. I need the following to taken from the SQL data and converted into an excel: · members name, · payment date, · membership payment amount · membership level · event name · event payment amount paid · amount due in 2017 ideal but not required · Date joined for new members would be helpful but not required · amount donated The goal is to give the auditors a list of all members and payments that are from the old system (the bak file) that should match our Quickbooks. Right now we don't have a way to read this bak data with the normal human eye. I'm not sure how many rows are in the file but I know I will need it only be 7-8 columns with roughly 400-700 rows (members)
Project ID: 17242716

About the project

31 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
Hi, my name is Selim. I read your "SQL to Excel" data project descriptions carefully before bidding. I checked the attached documents as well... I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star data processing and MS Office expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar tasks, including extraction of datbases from various formats into excel, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare a sample task for you to check & validate, once you give me a reply...regards.
$900 USD in 3 days
5.0 (304 reviews)
8.1
8.1
31 freelancers are bidding on average $1,134 USD for this job
User Avatar
Hello, I had a look at attached xls files and I am pretty sure I can generate similar reports for you. Looking forward to serve you with excellent time bound services. Regards
$941 USD in 15 days
5.0 (152 reviews)
9.3
9.3
User Avatar
Hi there, I have read initial requirements and as per my understanding, a report is to be generated from the SQL backup file which will match with the Quickbooks. We have few questions which are given below: - Only one report is to be generated or it will be based on different criteria and filters? - Kindly let us know that all of the columns related to payment amounts will only be fetched from the database columns or these are to be calculated while generating the report at runtime? You may ignore the bid & once you answer above questions, I can then estimate it precisely. Look forward to hearing from you. Regards, YK LEADconcept
$4,117 USD in 60 days
5.0 (61 reviews)
8.5
8.5
User Avatar
Dear Client, We are interested in your project. We have done similar projects and we can help you with this. You can check our profile and reviews, we do only good work. We look forward to hearing from you. Kind Regards, Safeer Ali Eagles Inc.
$850 USD in 10 days
5.0 (179 reviews)
8.3
8.3
User Avatar
I am 100% sure, I can do this. I will restore the .bak file data into my SQL server. It will create a database. After that we can generate any required data using query and store procedures. Ready to discuss in details. Highly experienced in VBA, SQL . Thank You
$1,000 USD in 5 days
5.0 (269 reviews)
8.1
8.1
User Avatar
Hello, I am Excel expert and VBA Developer with auditing experience. If interested, contact me Thanks
$1,000 USD in 14 days
4.9 (155 reviews)
8.2
8.2
User Avatar
I just go through your attached file, in excel files there are Members Details like First name, Last name, Registration date, Registration charge description, Total charge, Balance due, Payment method are present. In 2013-Membership-Dues spreadsheet file there are OpenId, Membership Status, Total Amount, Payment Instrument. In Online Final-Membership-2014 file there are Members Details like Membership_startdate, Source, Membership_status, Contribution_status, Recieved_date, Payment_Instrument are present Also Checked your database backup file where I found Tables like- ActionPlan, ActionMain, AddressMain, AppealProduct, GroupTyperef, Paymentmain. Storeprocedure also checked like- ConvertWorkPayment, ConvertWorkInvoices. Function and Views are also there like-GetCMNotificationsDuedate functions and vBoActionPlan View. To convert SQL data to Excel file need the HTML markup consists of a Button which when clicked will trigger the process of exporting the data from SQL Server table to Excel file. When the Export button is clicked, the event handler is executed. A DataTable is populated with records from the Customers table. Then a Workbook object is created to which the DataTable is added as Worksheet using the Add method which accepts DataTable and the name of the Sheet as parameters. Once the DataTable is added as a Worksheet to the Workbook, the WorkBook is saved to a MemoryStream. Finally, MemoryStream is written to the Response which initiates the File download.
$1,323 USD in 20 days
5.0 (67 reviews)
8.1
8.1
User Avatar
I can read the bak file and can convert the data to Excel sheet, as requested.. Please contact me for a free sample before award. ZERO ERROR GUARANTEED!! Please read my 350+ reviews. I am here to impress you with my work.
$1,000 USD in 7 days
4.9 (317 reviews)
7.8
7.8
User Avatar
Hi Did you try to read this bak file with QuickBooks? Isn't it a quickbooks back up file? .
$941 USD in 7 days
5.0 (406 reviews)
7.8
7.8
User Avatar
Hi, We have downloaded 100+ mb .bak file. Trying to open it, Hope we can get all the detail specified in project requirement. Get back to you shortly. Thanks
$900 USD in 1 day
4.9 (254 reviews)
7.9
7.9
User Avatar
I can convert your SQL data into excel easily .. please have a look my profile and its feedbacks . .i am prefect person for this job. i am waiting for your kind response .
$750 USD in 6 days
5.0 (74 reviews)
8.0
8.0
User Avatar
Hi there 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. Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that 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
$950 USD in 7 days
4.9 (168 reviews)
7.8
7.8
User Avatar
Hi, Hope you are doing great! As per the need, you wish to create a Accounting system and here are couple of points that I wish to clarify:- 1) What all the elements do you wish to fetch from Quickbook? 2) Do you wish to integrate this into an existing system or wish to create a complete new system? 3) Do you have any reference for the same? Kindly provide the project specification, so that I can have clear understanding of the project and can take things forward from there. I have mentioned a ball park estimate at the moment, once i have the details will provide you with the exact quote. *Rest assured Time & price will not be a deal breaking factor between us. I can start off as soon as I am being awarded the task. Anticipating your positive response. Regards, WPOPPO
$1,323 USD in 30 days
4.9 (125 reviews)
8.0
8.0
User Avatar
Hi, I can do the required tasks, I did a lot of similar files during my career. I served as CFO, Controller, and Chief Accountant at global parent companies. I have experience with implementing information systems in organizations and businesses (Intuit QuickBooks, SAP, ERP, etc.), within a multi-currency environment and the global marketplace, especially, in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, including collections, payments, inventory, and taxation. I am also a guru in Excel and VBA. I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. More on that, I develop financial modules including business valuation methodology & ratios (INPV, IRR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.)
$1,000 USD in 5 days
4.9 (104 reviews)
7.5
7.5
User Avatar
Dear Employer, Hope you are doing well...!! Coming to your project scope we will convert the SQL data to excel file of member report with member name,payment date,membership payment amount etc. I have gone through the attached document mentioned in project description and we have few queries which we need to discuss with you so that we can take this project to development stage. I will be wait for your reply Warm Regards Sam
$1,058 USD in 15 days
4.8 (50 reviews)
7.8
7.8
User Avatar
Hi, I am SQL certified professional and understand the project requirements. I can complete the project and 100% satisfaction is guaranteed. you may read reviews about my past work on my profile. Looking forward to discuss more and an opportunity to work with you. Thanks Muhammad Alyas
$1,000 USD in 3 days
5.0 (90 reviews)
7.2
7.2
User Avatar
Hello Sir, I am an expert with SQL Server and excel reporting and I can help you here with this project. Thanks Aanvik
$1,176 USD in 20 days
5.0 (58 reviews)
6.9
6.9
User Avatar
Hello, Hope you are doing well. I have 6 years of experience on Linux , SQL and Excel. I'm ready to take this project. Regards, VishnuLal
$1,000 USD in 10 days
5.0 (278 reviews)
6.9
6.9
User Avatar
HI, I am an expert DBA, working with SQL Server and the main commercial database like MYSQL, PostGre. I am downloading your bak file to understand how to open it. I will let you know asap. Armando
$1,000 USD in 20 days
5.0 (19 reviews)
7.0
7.0
User Avatar
As we hold freelancer preferred badge we are most promising team for that we have team of 27 developer with avg exp of 4 year. Please come om Pm to discus more and start project soon Talented team is here for your website. I have done same kind of function in past for the same reason we have great understanding of your requirements. We can start project asap. To get desired result we have team of 27 qualified software eng. Please come on PM to discus more and start right way Regards Dsv Infosolutions Pvt. Ltd.
$1,411 USD in 20 days
4.6 (75 reviews)
7.5
7.5
User Avatar
Hi, I have checked attached files .bak file: we can restore this in SQL Server Management studio Can we discuss details so i can understand flow of processing this bak file and insert data in excel files Thanks
$1,000 USD in 3 days
5.0 (51 reviews)
7.0
7.0

About the client

Flag of UNITED STATES
Washington,, United States
5.0
1
Payment method verified
Member since Jun 26, 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.