[postgis-users] Excel connecting and inputting into PostGIS

[ruvenml at beamerbrooks.com]

SQL Workbench/J can read/write Excel files directly.   It's pretty much 
a replacement for pgAdmin and for most of the things that are done in psql.

Ruven Brooks


On 8/15/2020 10:39 AM, Paolo Cavallini wrote:
> The easiest I know of is through QGIS.
> Cheers.
>
> On 15 August 2020 17:07:06 CEST, Imre Samu <pella.samu at gmail.com> wrote:
>
>     > Is there a simple way for users to load their data into PostGIS?
>
>     CSV?
>     -  save as a CSV file  ( contains LAT , LON columns )
>      - import CSV to Postgres
>     -  convert LAT/LON  to geometry columns ...
>     https://stackoverflow.com/questions/2987433/how-to-import-csv-file-data-into-a-postgresql-table
>     <https://stackoverflow.com/questions/2987433/how-to-import-csv-file-data-into-a-postgresql-table>
>
>     or scripting?  ( Python; Julia, R , ...  )
>     or any DB tool?  ( https://dbeaver.com/docs/wiki/Data-transfer/
>     <https://dbeaver.com/docs/wiki/Data-transfer/> ; PGAdmin4:
>     https://www.youtube.com/watch?v=Ikd2xSb00UI
>     <https://www.youtube.com/watch?v=Ikd2xSb00UI> )
>
>     Imre
>
>
>
>
>     Shaozhong SHI <shishaozhong at gmail.com
>     <mailto:shishaozhong at gmail.com>> ezt írta (időpont: 2020. aug.
>     15., Szo, 15:35):
>
>         Scenario:  Many Excel users seek to contribute data to
>         PostGIS.  Excel can be connected to PostGIS via ODBC.
>
>         Is there a simply way for users to load their data into PostGIS?
>
>         Regards,
>
>         Shao
>         _______________________________________________
>         postgis-users mailing list
>         postgis-users at lists.osgeo.org
>         <mailto:postgis-users at lists.osgeo.org>
>         https://lists.osgeo.org/mailman/listinfo/postgis-users
>         <https://lists.osgeo.org/mailman/listinfo/postgis-users>
>
>
> -- 
> Please excuse my brevity.
>
> _______________________________________________
> 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/20200815/86334f7c/attachment.html>