Importing from Microsoft Excel

Visual Studio .NET 2003

When you import worksheet data, Visual FoxPro uses the first row in your Microsoft Excel worksheet to determine the data types of the fields in the new table. If the first row has literal text headings for each column, all the fields in the table will be character fields, even if the rest of the rows contain numeric data.

To make sure fields have the appropriate data type

  • In Microsoft Excel, modify the worksheet so that the first row contains the first record of data you want in the table.
    Caution   If a field in your Microsoft Excel worksheet has a field length of 255, that field is truncated to 254 when it is imported to a Visual FoxPro table.

See Also

Translating Lotus Date Fields | Process of Appending Data | Importing and Exporting Data | Importing from Lotus 1-2-3 | Importing Data with the Import Wizard | Process of Importing Data

Show: