Filter/Query According to a List of Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm slowly sorting through the other possibly relevant posts, but in case
nothing turns up:

I have a database full of property data. Each property has a unique
identifier (number).

I have an Excel spreadsheet that lists a couple hundred of these property
identifiers.

Is is possible to query and/or filter my data so that I only extract the
properties that are indicated on my spreadsheet, and if so, how? I have
looked into Query by Form, but it did not seem appropriate.

Thanks!
 
Diana:

One approach would be to link your Excel spreadsheet into Access (File menu,
Get External Data, Link Tables..., in the Files of Type combo box select
"Excel" and browse to your Excel workbook).

After you link your Excel worksheet, you can create a query joining your
existing property table with your linked Excel spreadsheet.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I'm slowly sorting through the other possibly relevant posts, but in case
nothing turns up:

I have a database full of property data. Each property has a unique
identifier (number).

I have an Excel spreadsheet that lists a couple hundred of these property
identifiers.

Is is possible to query and/or filter my data so that I only extract the
properties that are indicated on my spreadsheet, and if so, how? I have
looked into Query by Form, but it did not seem appropriate.

Thanks!
 
Hi David,

Thanks for the tip. However, I get the error message "type mismatch in
expression" when I try to query only for properties in the database that
"equal" those in my Excel spreadsheet. Both are number types, as far as I can
tell. Any ideas?

Then there is a further problem, where, after attempting to match the
identifiers, I try to get data associated with the identifiers out of the
database, and it claims that my query "contains ambiguous outer joins." I
cannot figure out exactly how the join is ambiguous.

Diana
 
I solved the type mismatch problem, and the outer join problem. Turns out one
of the fields was text, and one was number. To solve the outer join issue, I
created two different queries, and created a new query that called the two
previous queries for the data I wanted.

Now.. the issue is, the data I got is not what I expected. In fact, there
seems to be something severely wrong. I got 65,000 results for ONE
identifier! I don't know how that is possible since the identifiers are
supposed to be unique.
 
Back
Top