Hi all
I have had a similar in the past, where I import an excel file and not only
the values, but also the field names, are shortened by one character.
Annoying to say the least. It doesn't happen every time, but used to happen
sometimes with MI5.5 and now does with 6 too.
any ideas?
thanks,
Caroline
----- Original Message -----
From: Phillips, Andrew <[EMAIL PROTECTED]>
To: Mi-L (E-mail) <[EMAIL PROTECTED]>
Sent: Tuesday, May 08, 2001 9:33 PM
Subject: MI-L MI: fields shortened upon Excel import
As the title suggests, upon importing an Excel file, numeric fields are
shortened from 6 to 4 decimal places. Yipes. Never has happened to me
before, though I've performed the operation many times. I've triple-checked
that the fields are formatted correctly in Excel (to the point of exporting
the file as text and reimporting it to Excel), and that there are no
extraneous characters in the nether regions of the spreadsheet. I'm using
MI6 and select the "Use Row Above Selected Range..." option.
I know that I could simply import the text file mentioned above, but that
doesn't solve the fundamental problem. Are there other subtleties to
importing spreadsheets that I have overlooked?
Regards,
ACP
************************
Andrew Phillips, Ph.D.
Illinois State Geological Survey
615 E. Peabody Dr.
Champaign, IL 61820
217-333-2513
[EMAIL PROTECTED]
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
