FYI-below You can't edit a excel file in MI. But, you can edit/open a *.DBF in both. The danger is you could loose columns/rows of data.
-----Original Message----- From: Gary Murphy [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 1:06 AM To: [EMAIL PROTECTED] Subject: MI-L Mapinfo 7.0 - Updating Points When Using an Excel Table Hi I have an excel table simply displaying points within MI-7. I'd like to add/update/delete point data and somehow update the excel table from within Mapinfo. I'll obviously also need to ensure the new coordinates are recognised by Mapinfo (UK system). At the moment I just manually alter the excel table and have to create points each time. Is there an easier way to do this, or does it need an ODBC connection, and does this allow add/update/delete from within Mapinfo? Thanks, Gary Murphy -----Original Message----- From: Photogrammetry GIU [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 11:23 PM To: Cummings, Mike Subject: RE: MI-L Exchanging Values in MI Hi Mike If you use watcher.mb in samples/snippets as a basis, you could hack the code to set Excel cells to particular values. You need Excel running, of course, but it is not beyond the wit of man to use this to read an excel spreadsheet and then to set another cell to a particular value. On the other hand, as economists say, this is probably a sledgehammer to crack a nut. I would do the editing directly in Excel. Tony >>> "Cummings, Mike" <[EMAIL PROTECTED]> 26/05/2004 17:01:44 >>> Footnote: You can't edit a excel table in mapinfo. (Or, at least, not the version I'm using(6.5)) So, you may have to use excel. -----Original Message----- From: Sloan Ritchie [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 8:43 AM To: [EMAIL PROTECTED] Subject: RE: MI-L Exchanging Values in MI Easy in Excel: =IF(A1=0,"W",IF(A1<4.5,"G",IF(A1<9.5,"B","R"))) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 8:01 AM To: [EMAIL PROTECTED] Subject: MI-L Exchanging Values in MI Hello I have a spreadsheet with a specific value in each cell. Now I would like to exchange the value with a letter. The following condition should be used for it. * If x is exactly 0 then add a "W" (x=0) * If x is higher than 0, but smaller than 4.5 then add a "G" (0<x<4.5) * If x is 4.5 or higher, but smaller than 9.5 then add a "B" (4.5<=x<9.5) * If x is 9.5 or higher then add a "R" (9.5 <=x) How could I solve that problem with Excel, MI or should I use MapBasic? Thank you for your help. With kind regards Christian christian cattaneo Bundesamt f�r Verkehr BAV Bollwerk 27/29 CH-3003 Bern e-mail: [EMAIL PROTECTED] oder [EMAIL PROTECTED] tel: +41 31 325 12 78 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11913 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11915 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11955
