External table is not in the expected format
I use a DB Table / Excel worksheet that has the parameters for my test that are run in iterations. Lately, I get this randomly. External table is not in the expected format Has anyone seen this er...
Forum Discussion
Am running from within the IDE that is installed in Program Files (x86). Because it's in the (x86) folder, I assumed it is 32 bit, but Task Manager clearly shows it's 64 bit.
TestComplete and TestExecute are shipped with both 32 and 64 bit flavors and both are installed in the "Program Files (x86)" folder.
C:\Program Files (x86)\SmartBear\TestComplete 15\Bin\*.exe
C:\Program Files (x86)\SmartBear\TestComplete 15\x64\Bin\*.exe
Use Windows "Task Manager" > "More details" > Details > and look at the Image path name for the correct version you are running. Most likely the 64 bit.
To access Excel you also need proper Microsoft Office driver dependent on your Office version, as well as TesCOmplete/TestExecute bit version explained in this Using Excel Files as Data Storages | TestComplete Documentation (smartbear.com)
Also you may find that such Microsoft Office drivers are no longer available, saving your file in a lower version of Excel version (such as .xls not ,xlsx) may solve your problem.
