Good plan. Thanks for that suggestion, it will make life a lot easier.
Caroline
----- Original Message -----
From: John Haynes <[EMAIL PROTECTED]>
To: DopeyLSPLSP <[EMAIL PROTECTED]>; Caroline Hilton
<[EMAIL PROTECTED]>; MI-L <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 5:59 PM
Subject: Re: MI-L MI: fields shortened upon Excel import
Doubly support this solution. The export to a delimited ASCII file (we use
tab delimited) solves MANY problems generated by excel.
John Haynes
Director
Geodata Consultants, Inc.
1-800-838-6661
www.geodataconsult.com
----- Original Message -----
From: "DopeyLSPLSP" <[EMAIL PROTECTED]>
To: "Caroline Hilton" <[EMAIL PROTECTED]>; "MI-L"
<[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 12:55 PM
Subject: RE: MI-L MI: fields shortened upon Excel import
> Perhaps it's best just to export the excel file to a comma delimited or a
> pipe delimited text file and then open in MapInfo. Works fine. It
happened
> to me all the time, with excel. Furthermore, for some excel versions, it
> sometime cuts off any rows that exceeded a certain number of rows. Text
> file usually works around that problem.
>
>
> --
> Erick Posner
> --
> http://posner.freeyellow.com/ErickPosner.htm - Resume
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Caroline
> Hilton
> Sent: Wednesday, May 09, 2001 2:33 AM
> To: MI-L
> Subject: Re: MI-L MI: fields shortened upon Excel import
>
>
> 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.
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
>
>
> _______________________________________________________________________
> 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.
