TMPCLP file???

[yland1]

I am VERY new to pivot tables. When I try to get data from Access database, I
find the file I want, and then in the query wizard part there are several
available starting with TMPCLP. What is this? They seem to be dups of other
available tables but why is this happening??

 

[John G]

These are "Temporarily" stored and/or deleted Queries/Tables in the Access
Database itself (Access never really "deletes" old tables/queries).

If you run a Compact/Repair on the Access database it will clear them out.
It's by design and they are harmless albeit a bit confusing when setting up
data connections for the first time