Also keep in mind that Excel has the row limit of around 65,000... so a .dbf with more records will truncate.
-Ross E. Bagwell GIS Manager Universal Access Inc -----Original Message----- From: DeVries, Eric SSgt - XIII [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 9:20 AM To: 'MapInfo-List Lists' Subject: RE: MI-L Exporting mapinfo table such that m$ excel ca Personally, I like to just save the files as .dbf, regardless of if I will be looking at them in Excel *OR* MI Pro. This allows me to edit the file if it's opened in MI Pro if I need to, whereas opening an Excel file in MI Pro limits me to read-only. Eric DeVries, SSgt, USAF NCOIC Visualized Intelligence HQ Air Force Office of Special Investigations DSN 857-0827 (240) 857-0827 -----Original Message----- From: Darrin Clement [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 5:42 PM To: Phillips, Frank; [EMAIL PROTECTED] Cc: 'MapInfo-List Lists' Subject: RE: MI-L Exporting mapinfo table such that m$ excel ca You can just export it as type dbf but for the name, overwrite the .dbf extension with .xls . Excel will then open it fine, but you will have to resave it in Excel as a true excel file if you want to save any special formatting. Darrin -----Original Message----- From: Phillips, Frank [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 3:00 PM To: '[EMAIL PROTECTED]' Cc: 'MapInfo-List Lists' Subject: RE: MI-L Exporting mapinfo table such that m$ excel ca <can anyone tell me whats the easiest and most effective ways to export a mapinfo table such that it can be manipulated in m$ excel??? what should we save the mapinfo table file as such that we can open it up in m$excel??? > Michelle, I'm just a beginner at MapInfo (I'm an ESRI veteran), but I do know a bit about how Excel deals with tables. Aside from using DDE (I think it's called "poke") to transfer the table, you can manually export the table as a DBF or as a comma delimited file (CSV) and then open that file in Excel. The one caveat about using a comma separated file is that it will drop leading zeroes in your data (if you have any), and if your data contains any commas then Excel will read up the file incorrectly. This is the reason I always export a DBF from MapInfo (or ArcView) and then open it in Excel. There's one other caveat for DBF, though. When Excel opens a DBF, it makes a "mental note" about the number of rows and columns in the DBF, and if you work in that same DBF and add or delete any rows or columns and then re-save, it will act like it's saving correctly, but will actually keep the number of rows and columns the same. For this reason, I use the workaround of first opening the DBF, then copy/paste into a virgin Excel sheet for working and saving. Then I go and delete the DBF I exported. Hope this helps. Frank Phillips Manager of Marketing GIS Vulcan Materials Company (NYSE:VMC) Birmingham, AL, USA ------------------------------------------------------------ --------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7015 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7019 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7040 This communication contains information from Universal Access, Inc. (or its affiliates) which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7042
