Find Jobs
Hire Freelancers

Build a SQL in Excel

$10-30 USD

Completed
Posted over 5 years ago

$10-30 USD

Paid on delivery
Need help building a report using SQL in Excel. Here is the problem I am trying to solve: I am generating an excel for reporting by querying SQL databases. Here is what I am trying to achieve: I want a way to Use Column A from Sheet 1 in a SQL query in Sheet 2 within an IN operation. Eg: In sheet 1-> column A, I have a few values A1: 'ABC' A2:'XYZ', ...... In sheet 2, I want to write a SQL query which does a SELECT * FROM table WHERE Value IN (Values from Sheet1's Column A) => IN ('ABC', 'XYZ', .....) Can you help me with this? Thanks.
Project ID: 18013744

About the project

13 proposals
Remote project
Active 5 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 am a database expert with 15 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. I am equally good with Excel - excel formulas, pivots and vlookups. Your requirement of generating the SQL statement from the excel values can be done using Excel formulas. this is some thing I always use to do, generate the insert/ update sQL sattaments from excel cell values using formula. Can you please send me the excel file, and I can send you the required SQL. Can work on it right now. Thanks Roni
$10 USD in 1 day
5.0 (60 reviews)
6.0
6.0
13 freelancers are bidding on average $21 USD for this job
User Avatar
Dear Employer, I have completed very similar projects in the past. I have a excel VBA macro ready for it. Please let me know if interested we can have a further discussion regarding the same.
$15 USD in 1 day
4.5 (31 reviews)
4.2
4.2
User Avatar
Hi, I am an Excel Expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Thank you Awaiting your response.
$30 USD in 1 day
4.4 (34 reviews)
4.1
4.1
User Avatar
"Hi, I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your current project and able to provide accurate and quick service. You know! I’m efficient and experienced data entry worker. If you consider me for this job, I will try my level best to complete your project within our committed deadline. I look forward to hearing from you about the project. Regards"
$50 USD in 1 day
4.9 (13 reviews)
3.4
3.4
User Avatar
I can do this SQL query using your Excel Data., I am 12 yrs Experienced in Excel,Python,Php, Office/web Automation & blogging on Office Tricks & tips. I work full time in here & will be able to start your work immediately.
$10 USD in 1 day
4.3 (6 reviews)
1.8
1.8
User Avatar
hi there, I have gone through your description and understood your requirements Kindly ping me that we can discuss in depth, Thanks Have a great day
$15 USD in 1 day
5.0 (1 review)
0.6
0.6
User Avatar
Hello, Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project using Vlookup in excel sheet. A brief summary of my profile as following. Over 12 years of experience in IT field of software development and support. On technical front I have good experience on following technologies. Databases : SQL Server, Universe/Unidata, Oracle,MS Access. Development Technologies: C#,Winform, WPF, ASP.Net MVC, Pick Basic/UniBasic, Visual Basic 6, Excel VBA. Reporting/Designer Tool: SSRS, Crystal Reports, System Builder(SB+). I would very much enjoy having the opportunity to talk with you further to discuss the requirements and expectations regarding the project, and how I could use my skills to benefit you. Thank you for considering my application. I look forward to hearing from you. Regards, Naveen Upadhyay
$20 USD in 1 day
5.0 (1 review)
0.8
0.8
User Avatar
"Hello, As per my assuming you need a data entry expert.I have carefully gone through with your requirements and I would like to help you with this job. I have about five years experience in the field of Data entry, Data Extraction, Web Search. I’m ready to assist you from right now. I would love to finish it within the agreed deadline. Feel free to visit my profile and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hear from you soon. Regards."
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been using Excel since it was first released in about 1992. This includes multi sheet, formulas, functions, macros and Visual Basic. I am confident that I will be able to achieve what you require. I am a Certified Microsoft Solution Developer. SQL is included as one of its five modules. I have also used SQL for at least 2 years in a working environment. My career was in developing computer systems so have programmed in many computer languages. This has required a very detailed and logical way of looking at problems. I have a Bachelor of Science in Computer Science and Business Information Systems (Cum Laude)
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
It is simple to generate the columns values if sheet in the condition. Contact me @ my mail form further discussion
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Arlington, United States
5.0
8
Payment method verified
Member since Jan 22, 2012

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.