Is there a way to force MapInfo to register an Excel file with all fields as Char using the Register Table command?MapInfo is 'helpfully' assigning the Float data type to a column that contains data that is all numbers but some values have leading zeros. This is an ID field and needs to be imported as Char. Looking at the help, there isn't a way to do this.
Has anyone found a workaround?
Thanks!John HollingsworthP.S. Acceptable answers do not include, "Just edit the Excel file before you import it to have an alpha character in that field"
I've done this, but unfortunately, when there are values with leading zeros either Excel or MapInfo replaces the entire value with a zero. So data is lost and cannot be recovered.
It seems to me like in the past in this circumstance that MapInfo would convert the field to Float and keep all of the digits except for the leading zero. That was easy because I could just convert the field to Char and then replace the leading zero. But now they are all 0 values.Does anyone know if there was an update to the Access 2010 data drivers that Microsoft may have recently pushed that would be causing this new behavior?
Thanks for testing Eric.
I removed the empty cells and retested and got the same error message.Back to the drawing board...