MapInfo Pro

Apols if this has come up before.

I have an excel workbook with multiple worksheets. I have 2 different analyses, both of which I want to map, which are on different worksheets. They are derived from the same dataset, but different types of data, so I don't want them on the same sheet, and I don't really want to store them in different workbooks.

How do i get mapinfo to connect to both worksheets? It seems to automatically assume I always want the same one.

thanks

------------------------------
Martin Burroughs
Oldham Council
------------------------------

Martin,

You can sort of do it with an ODBC connection. I have managed to 'open' both worksheets at the same time.



Although these were only mappable via a join.

I couldn't figure out how to create a mapcatalogue to auto create points with.  And also, despite having co-ords in the data, it wouldn't let me create points either.

Let me know if you want me to talk you through it

HTH

Nick

------------------------------
Nick Hall
Mapchester LTD
Manchester
------------------------------

Original Message:
Sent: 05-26-2021 11:53
From: Martin Burroughs
Subject: Excel-tab files for 2 worksheets?

Apols if this has come up before.

I have an excel workbook with multiple worksheets. I have 2 different analyses, both of which I want to map, which are on different worksheets. They are derived from the same dataset, but different types of data, so I don't want them on the same sheet, and I don't really want to store them in different workbooks.

How do i get mapinfo to connect to both worksheets? It seems to automatically assume I always want the same one.

thanks

------------------------------
Martin Burroughs
Oldham Council
------------------------------

Thanks Nick!
I would want to create points though, so I guess I'll stick to cloning the book :-)

------------------------------
Martin Burroughs
Oldham Council
------------------------------

Original Message:
Sent: 05-27-2021 08:35
From: Nick Hall
Subject: Excel-tab files for 2 worksheets?

Martin,

You can sort of do it with an ODBC connection. I have managed to 'open' both worksheets at the same time.



Although these were only mappable via a join.

I couldn't figure out how to create a mapcatalogue to auto create points with.  And also, despite having co-ords in the data, it wouldn't let me create points either.

Let me know if you want me to talk you through it

HTH

Nick

------------------------------
Nick Hall
Mapchester LTD
Manchester

Original Message:
Sent: 05-26-2021 11:53
From: Martin Burroughs
Subject: Excel-tab files for 2 worksheets?

Apols if this has come up before.

I have an excel workbook with multiple worksheets. I have 2 different analyses, both of which I want to map, which are on different worksheets. They are derived from the same dataset, but different types of data, so I don't want them on the same sheet, and I don't really want to store them in different workbooks.

How do i get mapinfo to connect to both worksheets? It seems to automatically assume I always want the same one.

thanks

------------------------------
Martin Burroughs
Oldham Council
------------------------------

Hi Martin

The new OGR Vector Files format also allows you to open Excel files. Using this method, you can select multiple sheets from the same Excel file and open these during one process.

This method also allows you to automatically create points during the open process. Just make sure the potential X and Y column names have been set correctly to match your column names.

The support for OGR Vector files was added to MapInfo Pro v2021.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------

Original Message:
Sent: 05-27-2021 10:31
From: Martin Burroughs
Subject: Excel-tab files for 2 worksheets?

Thanks Nick!
I would want to create points though, so I guess I'll stick to cloning the book :-)

------------------------------
Martin Burroughs
Oldham Council

Original Message:
Sent: 05-27-2021 08:35
From: Nick Hall
Subject: Excel-tab files for 2 worksheets?

Martin,

You can sort of do it with an ODBC connection. I have managed to 'open' both worksheets at the same time.



Although these were only mappable via a join.

I couldn't figure out how to create a mapcatalogue to auto create points with.  And also, despite having co-ords in the data, it wouldn't let me create points either.

Let me know if you want me to talk you through it

HTH

Nick

------------------------------
Nick Hall
Mapchester LTD
Manchester

Original Message:
Sent: 05-26-2021 11:53
From: Martin Burroughs
Subject: Excel-tab files for 2 worksheets?

Apols if this has come up before.

I have an excel workbook with multiple worksheets. I have 2 different analyses, both of which I want to map, which are on different worksheets. They are derived from the same dataset, but different types of data, so I don't want them on the same sheet, and I don't really want to store them in different workbooks.

How do i get mapinfo to connect to both worksheets? It seems to automatically assume I always want the same one.

thanks

------------------------------
Martin Burroughs
Oldham Council
------------------------------