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.
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.