in Access tables that contain coordinates use the number format "Double". when opened in MI it will automatically become "Float".
i use up to 8 decimal places, and it works fine. in browser view in MI the column may appear to have only 3 decimal places, but it actually uses the same data as in your database. ash -----Original Message----- From: Jeff Card [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 18 February 2003 2:41 AM To: Karen Purdy; MapInfo-L@lists. Directionsmag. Com (E-mail) Subject: RE: MI-L Openin access table in MI I know next to nothing about Access but here is how I got around this problem. In Access, I had to set the field size to Decimal, the format type to General Number, the Scale to 5, and Decimal Places to 5. I was using my columns for Lat/Long values and 5 was the precision I needed. You should replace 5 with however many decimal places you need. There might be a better way but this solved the problem for me. -----Original Message----- From: Karen Purdy [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 9:57 AM To: MapInfo-L@lists. Directionsmag. Com (E-mail) Subject: MI-L Openin access table in MI Please can you help.... I have opened a table from an Access database in MapInfo, using FILE -> OPEN. Most columns from Access appear as fields in the MapInfo browser that is produced incl text and integer fields. However, decimal fields do not appear in MapInfo at all. Is there anyway to open these fields in MapInfo like the others, but as type float? Will SUM. Many thanks Karen ========================== Karen Purdy GIS Support Officer Peak District National Park Authority Email: [EMAIL PROTECTED] ========================== ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5543 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5544 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5550
