Many thanks to Jeff Card, Ashley Simmonds, and Richard Hammond for their help on this one - their emails are below after my original question.
I tried the various suggestions, but the only one that worked in my case was to change the 'decimal' fields in the access table to 'double' fields, and they then showed up fine (as float fields) in MI. Thanks again Karen -----Original Message----- From: Karen Purdy [mailto:[EMAIL PROTECTED] Sent: 17 February 2003 15:57 To: [EMAIL PROTECTED] Directionsmag. Com (E-mail) Subject: MI-L Opening 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] ========================== ========================== From: Simmonds, Ashley 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 ========================== From: Jeff Card 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. ========================== From: Richard Hammond I’m not at all sure that you need to select “double” for the number fields in access to be able to see them in MI. I have many such fields that are either “single” or “long integer”, just depends on what accuracy I want/need. The only fields that don’t come in, of course, are “memo” fields. Regards, Richard Hammond ________________________________________________________________________ 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: 5715
