Knowledge Base

ACC97: Error Importing or Linking to an Excel File in Access

Article ID: 200431

Article Last Modified on 1/23/2007

APPLIES TO

This article was previously published under Q200431
Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

When you try to import or link a table in a Microsoft Excel workbook, you may receive the following error message:
External table isn't in the expected format.

CAUSE

You may experience this problem when you try to import or link a table to an Excel workbook that uses functions from the Analysis ToolPak add-in.

RESOLUTION

Open the workbook in Excel and keep it open until you import or link to the workbook. You can then close Excel without receiving the error.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Access 97.

MORE INFORMATION

You may receive the error mentioned in the "Symptoms" section with the following functions from the Analysis ToolPak add-in: 
   ACCRINT      CUMPRINC    HEX2BIN      IMSUB         PRICE
   ACCRINTM     DEC2BIN     HEX2DEC      IMSUM         PRICEDISC
   BESSELI      DEC2HEX     HEX2OCT      INTRATE       PRICEMAT
   BESSELJ      DEC2OCT     IMABS        ISEVEN        RECEIVED
   BESSELK      DELTA       IMAGINARY    ISODD         SERIESSUM
   BESSELY      DISC        IMARGUMENT   LCM           SQRTPI
   BIN2DEC      DOLLARDE    IMCONJUGATE  MDURATION     TBILLEQ
   BIN2HEX      DOLLARFR    IMCOS        MROUND        TBILLPRICE
   BIN2OCT      DURATION    IMDIV        MULTINOMIAL   TBILLYIELD
   COMPLEX      EDATE       IMEXP        NETWORKDAYS   WORKDAY
   CONVERT      EFFECT      IMLN         NOMINAL       XIRR
   COUPDAYBS    EOMONTH     IMLOG10      OCT2BIN       XNPV
   COUPDAYS     ERF         IMLOG2       OCT2DEC       YEARFRAC
   COUPDAYSNC   ERFC        IMPOWER      OCT2HEX       YIELD
   COUPNCD      FACTDOUBLE  IMPRODUCT    ODDFPRICE     YIELDDISC
   COUPNUM      FVSCHEDULE  IMREAL       ODDFYIELD     YIELDMAT
   COUPPCD      GCD         IMSIN        ODDLPRICE
   CUMIPMT      GESTEP      IMSQRT       ODDLYIELD


Additional query words: pra external table isn t in the expected format

Keywords: kbbug kbpending KB200431


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.