[postgis-users] Looking for information for allowing Office 365 Excel to access and use map data stored on PostGIS.

[Shaozhong SHI]

Thanks, Stefan,

I can load in tables, but geometry column contains codes only.  It does not
show up as a map.

Regards,

Shao

On Tue, 12 Nov 2019 at 13:10, Stefan Wolf <sw at zpmt.de> wrote:

> Google for: odbc pass through query
>
>
>
> SQL *pass*-*through queries* are used to send commands directly to an
> *ODBC* database server. By *using* an SQL *pass*-*through query*, you
> work directly with the server tables instead of having the Microsoft Jet
> database engine process the data.
>
>
>
> You can use “normal” PostgreSQL-SQL syntax like in pgAdmin…
>
>
>
> Regards
>
> -Stefan-
>
>
>
>
>
>
>
> *Von:* postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] *Im
> Auftrag von *Shaozhong SHI
> *Gesendet:* Dienstag, 12. November 2019 13:26
> *An:* PostGIS Users Discussion
> *Betreff:* [postgis-users] Looking for information for allowing Office
> 365 Excel to access and use map data stored on PostGIS.
>
>
>
> Has anyone got such information?
>
>
>
> Looking forward to hearing from you.
>
>
>
> Regards,
>
>
>
> Shao
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20191112/08024c4a/attachment.html>