[postgis-users] Import excel file to postgresql

[José María Amuedo]

Hi,

I would like to know how can import excel file to postgresql. I'm working with linux OS.

Thanks

[Pedro Costa]

Hi José,

You have to convert the excel file to csv and use the copy command like that:


copy table_name from 'C:\Users\TEMP\filename.csv' WITH CSV DELIMITER ';';


You have to create the table before and delete the column names of csv file.

_______________________________________________
postgis-users mailing list
postgi...@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Horst Düster]

As an other option you can use an ETL-Tool like Talend OpenStudio [1] or Geokettle [2]

Regards
Horst

[1] http://www.talend.com/index.php
[2] http://www.spatialytics.org/projects/geokettle/

[Ralf Suhr]

Hi José,

 

ogr2org can import excel files for you. http://www.gdal.org/ogr/drv_xls.html Or you compile gdal/ogr from svn then you can also import xlsx files. http://www.gdal.org/ogr/drv_xlsx.html

 

 

Gr

Ralf

[José María Amuedo]

I obtened this error:

RROR: extra data after last expected column
SQL state: 22P04
Context: COPY nueva, line 1: "CODIGO;TIPO;DESCRIPCION;REPRESENTACION;PERFIL;CLAVE;VER3D;CARACBUSQ;LETRA;CAPITULO;SUBCAPITULO;ESTA;..."

2012/6/13 Pedro Costa <pedroco...@sapo.pt>

[Pedro Costa]

Send me a sample of your file. But you have to remove the last semicolon.

Your file have to be like that:


column1;column2;column3;333333.3333
column1_r2;column2_r2;column3_r2;333333.3333

[José María Amuedo]

this is my file

2012/6/13 Pedro Costa <pedroco...@sapo.pt>

[Pedro Costa]

Try with i sample attached.
be sure that your table must have columns according to the file