Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel query advice

Posted on 2011-09-29
3
Medium Priority
?
224 Views
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'
0
Comment
Question by:malraff
3 Comments
 
LVL 10

Accepted Solution

by:
ukerandi earned 1000 total points
ID: 36814375
See below link it will help you. i think you need to write VBA with ADO programme
http://support.microsoft.com/kb/321686
0
 
LVL 37

Expert Comment

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

Can you post a sample spreadsheet file?
0
 

Author Comment

by:malraff
ID: 36815275
I GOT THIS DONE WITH VB,

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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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‚Ķ

876 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