Microsoft KB Archive/100808

From BetaArchive Wiki

Notes for Using APPEND FROM to Add Data from Spreadsheet

ID: Q100808

The information in this article applies to:

  • Microsoft FoxPro for MS-DOS, versions 2.0, 2.5 , and 2.5a
  • Microsoft FoxPro for Windows, versions 2.5 and 2.5a

Keep the following points in mind when using the APPEND FROM command to add data to a database from a spreadsheet data file:

  • The spreadsheet should be constructed with the same number of columns as database fields. However, if the database (into which the spreadsheet is being appended) has more fields than the spreadsheet file, you can select the appropriate database fields into which the columns are to be appended by using the Fields option. For example, the first column will be appended into the first specified field and the second column into the second specified field.
  • If the number of columns exceeds the number of selected fields (the default is ALL fields if the Fields option is not used), any columns beyond the last database field will be truncated.
  • The type of data in the first column should agree with the characteristics of the first database field, the second column with the second field, and so on. If the field types do not match, data may be lost. For example, importing character data into a numeric field will result in data loss, but numeric data will appear in a character field as characters.

Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a datafile import KBCategory: kbprg KBSubcategory: FxinteropSpread


Last Reviewed: June 26, 1995
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.