Microsoft KB Archive/165037

= ACC97: "Import Data from Spreadsheet" Help Topic Incorrect =

Article ID: 165037

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q165037



Moderate: Requires basic macro, coding, and interoperability skills.



SUMMARY
The Microsoft Access 97 Help Topic "Import or Link Data from a spreadsheet" states the following about appending spreadsheet data to an existing table:

  Although you normally create a new table in Microsoft Access for the data, you can also append the data to an existing table as long as your spreadsheet column headings match the table's field names, or its column order is the same.

This information is incorrect. To append a spreadsheet that you are importing into Microsoft Access to an existing table, you must have matching column headings for the fields. Having the same column order is not sufficient.

Keywords: kbusage KB165037

-

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

© Microsoft Corporation. All rights reserved.