Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006

    Unanswered: Query pulling from wrong table

    Problem: I have a Db set that has a linked Excel spreadsheet table. I was using a query to pull data from that table. Now, I'm appending the Excel data to an Access table, and pulling the data from there instead. I updated the existing query (Table Field) to reference the Access table. The issue is that the query still wants to pull data from the Excel linked table.
    Not sure what I'm missing here, but if I could get a couple of things to double check it would be appreciated.
    I've done this before, without any hitches, but for some reason with this particular query, I can't seem to the data to pull from the access table. I'm at a loss at this point.

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 10
    Have a look in the SQL view of the query and check which table it's pointing at
    Home | Blog

  3. #3
    Join Date
    Sep 2006
    Nevermind, I found it. I was one of the relationship. Problem corrected. I have about 10 tables joined to the query, and it was only of the join properties kept pointing to the wrong date. My last brain cell found it.

    Sorry to waste your time.

    Thanks anyway.

Posting Permissions

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