Annoying "External table is not in the expected format" message (1 Viewer)

[Stm]

Dear all,

I have two Access Forms which each run few queries and then send out the results by email.
There are few linked tables to excel *.xlsx and some local tables, each query will join these tables to compute the results.

This program runs fine for long time until about one year ago, the program will sometime failed due to error "External table is not in the expected format".
If I resume the program, most of the time it will success without error.

At first I wonder if the problem is because of the content of the file, but I note that the error occur randomly, each time the error query may be different, but every time when I resume it, it will success.

I've tried to search for answer, but no luck still have no idea how to fix it.

If you have similiar experience, could share to me??

Thanks.

 

[CJ_London]

Is the file actually a.xlsx or a .csv or.txt file?

If not a .xlsx then opening either of the other two formats as a .xlsx can change the format.

personally I never import from excel formats and use .csv as it is more stable

as for testing, rather than just continuing, abort the process and inspect the table and file for issues