IBM Support

Microsoft Access Database Engine 2007-2010: External table is not in the expected format.

Troubleshooting


Problem

Microsoft Access Database Engine 2007-2010: External table is not in the expected format.

Symptom

When exporting data from IBM i2 iBase v8.x.x into a Microsoft Excel spreadsheet with Microsoft Office 2007 installed and then importing the Excel spreadsheet into i2 iBase v8.9.5 with Microsoft Office 2010 causes the following error to appear:

Microsoft Access Database Engine 2007-2010: External table is not in the expected format.

Cause

This issue is caused if there are different versions of Microsoft Office installed on the source and destination systems

Resolving The Problem

In order to get the import to work, the file that is attempting to be imported must be opened and resaved as a newer Excel file format - .XLSX This should then allow the user to select the file for import as normal.

[{"Product":{"code":"SSXW43","label":"i2 iBase"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.9.5","Edition":"All Editions","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

More support for:
i2 iBase

Software version:
8.9.5

Operating system(s):
Windows

Document number:
248481

Modified date:
16 June 2018

UID

swg21682433

Page Feedback