[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Excel to Postgres
From:       Kis_János_Tamás <kijato () gmail ! com>
Date:       2010-02-16 17:49:31
Message-ID: cd5062411002160949w3f204427pef3bb4a4d6b2575f () mail ! gmail ! com
[Download RAW message or body]

Why don't use a small perl script with DBD:Excel and DBD::Pg packages?

2010/2/15  <Steve.Toutant@inspq.qc.ca>:
>
> Hi,
> Every day I receive an Excel file containing lat long coordinates. I need to
> import it to postgis.
> Currently, I save the Excel file in CSV format and I use ogr2ogr to import
> the contents into postgis. I would like to avoid human intervention.
>
> I tried unsuccessfully  to define an ODBC link on the Excel file and use
> ogr2ogr with odbc to import it to postgres/postgis.
> I got this error
> [Microsoft][ODBC Excel Driver] External table is not in the expected format
>
> Here is the command I sent
> ogr2ogr -f "PostgreSQL" PG:"host=xxx user=xxx password=xxx dbname=geo"
> "ODBC:odbc_urg,test" -nln "testODBCxls" -overwrite
>
> where test is the sheet name inside the excel file
>
> Anyone has a better idea on how to programmatically import excel data into
> postgis?
> thanks
> Steve
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]