Access External Data results in ~TMP files

sumdumgai

Registered User.
Local time
Today, 06:45
Joined
Jul 19, 2007
Messages
453
Running Office 365 (Access 2013). Recent problem occurrence. When I do an 'External Data' command, either from another Access database or an Excel file, the import completes, but I don't see the new table immediately in the navigator section. If I import from another Access database, the new imported tables appear as '~TMPCLP....' tables. If it's from an Excel workbook, the new table doesn't appear at all. It's only after I exit the database and reopen it do I see the new tables correctly named. Any help would be appreciated.
 
More info. I found that if you click on the ‘Tables and Related Views’ item in the navigator pane, the newly imported tables and queries will appear. Is this normal?
 

Users who are viewing this thread

Back
Top Bottom