Excel Data Querry using criteria from Cell


G

Guest

Hello, I have created a data query in Excel using DATA - IMPORT EXTERNAL DATA
- NEW DATABASE QUERY and then selecting Access and browsing to an query
within an Access database. This query returns all data into excel, but I
would like to limit the criteria based on what a user has typed into a cell
in the Excel workbook. I thought this could be accomplished by clicking DATA
- IMPORT EXTERNAL DATA then PARAMETERS but the PARAMETERS option is grayed
out. I can select EDIT CURRENT QUERY, but this just brings me into the
Microsoft query, where I don't see any options to query based on a call. Any
ideas how I can do this?
 
Ad

Advertisements

G

Guest

Is there a way to do this using an entire column as OR criteria in the query?
What I have is a column full of ID's in excel, and I need to pull three
colums out of a database for each ID, and in some cases it is thousands of
ID's, so typing each one in or selecting each cell would be rather
cumbersome. Thank you for any help.
 
N

Nick Hodge

John

I would export the data as table (linked or otherwise) to the database and
then run a query against this new table to restrict the new query to just
these numbers and then return to Excel using this new query in the database

--

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
 
Ad

Advertisements

G

Guest

I was afraid of that. Thank you very much for your help. I learned a good
deal from your website.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top