Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Query based on outside data

    We've got a list of items in an excel sheet. Those items are the same as some in a field of out access database. Is there a way to write a query so that it only shows the items that match between the two?

  2. #2
    Join Date
    Sep 2004
    Charlotte, NC
    Create a new table by linking to the worksheet in the Excel file. Then create a select query with an inner join between the field(s) in the newly linked table and the field(s) in the table that you already had in Access. This will return the matched records.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts