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