ACC97: "Import Data from Spreadsheet" Help Topic Incorrect (165037)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 9/26/2003 |
|---|
| Keywords: | kbusage KB165037 |
|---|
|