Product: MapInfo
Version: 5.0
Platform: Window NT40
Category: File Operations
Summary:
Blank cells in Excel file
Question:
When opening an Excel file in MapInfo, several cells are appearing empty. Why?
Answer:
The problem is cause by the way the field was created in Excel. This field was created by concatenating two fields together (using a formula to create the field). MapInfo doesn't work well with columns created using a formula. To get around this problem, create the field using a formula through MapInfo. Open the Excel file in MapInfo and save a copy of the file through File>Save Copy As. Open the copy, add a column to the table through Table>Maintenance>Table Structure and update the field with the formula through Table>Update Column.
Last Modified: 11/06/1998 02:36:55 PM
|