Platform: Window NT40
Category: File Operations
Blank cells in Excel file
When opening an Excel file in MapInfo, several cells are appearing empty. Why?
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