Excel query advice

Posted on 2011-09-29
Last Modified: 2012-05-12
hi all

if i have a column A in excel with stock codes how do i write a query that will do the below for me in column B - i know how to create the connection and write the query i just don't know how to reference an excel entry :@

select QtyOnHand from InvWareouse where Stockcode = "stockcode from excel" and Warehouse= 'GG'
Question by:malraff
LVL 10

Accepted Solution

ukerandi earned 250 total points
ID: 36814375
See below link it will help you. i think you need to write VBA with ADO programme
LVL 37

Expert Comment

by:Neil Russell
ID: 36814468
Where is the Warehouse field?

Can you post a sample spreadsheet file?

Author Comment

ID: 36815275

sorry i thought i could just do some sort of lookup from excel!

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question