[postgis-users] Excel to Postgres

[Kevin Neufeld]

If your data was in CSV format, you could script PostgreSQL's COPY command to import the file to a table instead of 
using ogr2ogr.

http://www.postgresql.org/docs/8.4/static/sql-copy.html

But to avoid human intervention to create the CSV in the first place, a purchased solution might be to create an FME 
script to read directly from Excel and write to PostGIS.
http://www.safe.com/products/desktop/formats/microsoft-excel/index.php

Kevin


On 2/15/2010 1:03 PM, Steve.Toutant at inspq.qc.ca wrote:
>
> 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users