Microsoft KB Archive/200431

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

Article ID: 200431

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.