Before you open an Excel file in MI, verify that the cells that the
dates are in are not set-up as Date 04-Mar-97. Either set the cells
to read as General or Date 3/4/97. I ran a quick test using all 3
formats and only the cell set-up as Date 04-Mar-97 showed up as
unrecognizable date field.
Clayton L. Harry
GIS Analyst
CapRock
COMMUNICATIONS CORP.
-----Original Message-----
From: Declan Troy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 11:53 AM
To: [EMAIL PROTECTED]
Subject: Re: MI RE: Using Excel....
Mappers,
"Speaking" of importing Excel files. Does anyone have any tricks for
maintaining the integrity of dates and times when importing Excel files
into MapInfo. I find that Dates and Times as recognized by Excel are
coverted to decimal format in MapInfo but these are not readily interpreted
as Dates once there. Anyone with simple/elegant solutions?
Declan Troy
70.25N 148.37W
At 02:46 PM 8/22/00 +0100, you wrote:
>Thanks to all who replied.
>
>The answer wouldn't come as a surprise to many; You can view but cannot
>directly modify a number of different data formats, including Excel,
>without first saving to native MI format (File|Save Copy As...).
>
>You can confirm this yourselves, as I did, by searching the On-line
>Help. Search for 'Excel', 'Tables', 'Importing' etc...in fact, just
>about every search brings up a link to 'Tables You Cannot Update'...
>
>So it's no wonder I couldn't find it!
>
>One more to add to the wishlist: Improved on-line help for the idle
>and/or mildly stupid.
>
>
>Chris Martin
>GIS Consultant
>WS Atkins Consultants Ltd
>(01952) 201234
>
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
