How to convert a .Tab file to an Excel xls file

[Elliot Osuni]

Hi am Elliot, i am working on a project that requires me to move all
mapinfo .tab file and edit them in Excel VBA. please how can i change
the mapinfo .tab file to Excel file?

[Martin Spiers]

The .tab file doesn't contain any data - it just points to the actual data store (and provides some information to allow MapInfo to read it)
You can convert the data to something Excel will read by :
a) export to CSV
b) save as DBF
MapInfo can open .xls and .xlsx files, so there's no need to convert the data back again - just open the Excel files from MI.

--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

Disclaimer: This electronic communication and its attachments may contain confidential, proprietary and/or legally privileged information which are for the sole use of the intended recipient. If you are not the intended recipient, any use, distribution, or reproduction of this communication is strictly prohibited and may be unlawful; please contact the sender and delete this communication. MWH does not warrant or make any representation regarding this transmission whatsoever nor does it warrant that it is free from viruses or defects, correct or reliable. MWH is not liable for any loss or damage that occurs as a result of this communication entering your computer network.

The views expressed in this message are not necessarily those of MWH. This communication cannot form a binding agreement unless that is the express intent of the parties and they are authorized to make such an agreement. MWH reserves all intellectual property rights contained in this transmission. MWH reserves the right to monitor any electronic communication sent or received by its employees.This communication may come from a variety of legal entities within or associated with the MWH group.

For a full list of details for these entities please see our website at www.mwhglobal.com. Where business communications relate to the MWH UK Limited entity, the registered office is Terriers House, 201 Amersham Rd, High Wycombe, HP13 5AJ Tel: 01494 526240 and the company is registered in England as registration number 01188070. Where business communications relate to the MWH Constructors Limited entity, the registered office is as above and the company is registered in England as registration number 04635724

[Zery]

Hi,

I think the best shot is convert your TAB files to DBF files, you can do that from menu Table->Export.

HTH,
Zery
Powered by Telkomsel BlackBerry®

-----Original Message-----
From: Elliot Osuni <ellio...@gmail.com>
Sender: mapi...@googlegroups.com
Date: Wed, 16 Nov 2011 04:46:04
To: MapInfo-L<mapi...@googlegroups.com>
Reply-To: mapi...@googlegroups.com
Subject: [MI-L] How to convert a .Tab file to an Excel xls file

[Uffe Kousgaard]

Using CSV and DBF both mean goodbye to all geographic data (points,
lines, polygons).

Perhaps Elliot should describe if that is what he wants and what his
plans are with the data, once they have been edited in Excel VBA?

Regards
Uffe Kousgaard

[Elliot Osuni]

all i want is just to be able to use the values in the mapinfo tables in excel.

2011/11/16 Uffe Kousgaard <uf...@routeware.dk>

--
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.To post a message to this group, send email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

--
Elliot Osuni Kenoye

[Uffe Kousgaard]

Hi,

Besides exporting to CSV and DBF, you can also just select all records in MapInfo (in a browser window, query > select all) and then use copy/paste.

Regards
Uffe

[Treichel, Kent (MDOR)]

Exporting to .dbf will maintain the geographic data, won't it? Provided you don't add or delete records.

________________________________________
From: mapi...@googlegroups.com [mapi...@googlegroups.com] on behalf of Uffe Kousgaard [uf...@routeware.dk]
Sent: Wednesday, November 16, 2011 7:10 AM
To: mapi...@googlegroups.com
Subject: Re: [MI-L] How to convert a .Tab file to an Excel xls file

Regards
Uffe Kousgaard

--

[Scott Daugherty]

If you want to manipulate data in a xls file and then put it back into same geographic data you will need to maintain a unique field so you don't loose your geography.

Powered by Telkomsel BlackBerry®

-----Original Message-----
From: "Treichel, Kent (MDOR)" <Kent.T...@state.mn.us>
Sender: mapi...@googlegroups.com

[CDR Group]

Elliot

 

Select records in MapInfo

Copy

Go to Excel

Paste

 

John Ievers

CDR Group
www.cdrgroup.co.uk
www.browse-a-map.co.uk
Tel: 01433 621282
Fax: 01433 621292
Specialists in Geographic Information Systems

CDR Group is the trading name of Contract Data Research Ltd.
Registered address Eccles House, Eccles Lane, Hope, Hope Valley, S33 6RW.
Registration No. 1972326
VAT No. GB373 3117 67

[Elliot Osuni]

Thanks very much i figured it out.

2011/11/16 Martin Spiers <Martin....@uk.mwhglobal.com>

--
Elliot Osuni Kenoye

[Mancing mancing]

thaks for all contributors I got new knolege 

[Mohsin Hafeez]

Hi, would you please explain how to do it. I have massive geographic data - duplicate polylines and points under different layers. What I would like to do is ; remove all the duplicate values but keep all layers intact with existing styles. 

For this reason I was just thinking to export everything to excel and remove duplicates.

Any help will be great ! 

[John Hollingsworth]

There is also a hack that I use.

Export the table using MapBasic as DBF, but give it an xls extension so that Windows will recognize it as a file type associated with Excel. So when a user double-clicks the file it will automatically open windows with that file loaded.

Code:
Export <sometablename> Into "C:\somefile.xls" Type "DBF"


Caveat:
Once somefile.xls is opened in Excel, everything will be fine until you try to save the file. Then Excel will give you an error message like:

"somefile.xls" cannot be saved in the current format. To save your changes, click OK, then save it as the latest format.

Interestingly, using this hack with the xlsx extension does not work. The FileSaveAsDlg won't even allow you to specify xlsx as an extension.

[John Hollingsworth]

Once Excel prompts you to save as the latest format, then you can save as XLSX.

[John Hollingsworth]

Mohsin,

Since spatial objects do not survive migrating to Excel and back, I'm not sure this will work for you.

You mention duplicate objects in different layers. Can you describe that a little more?

On Thursday, January 3, 2019 at 2:02:42 AM UTC-5 Mohsin Hafeez wrote: