[postgis-users] Import excel file to postgresql

[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 <pedrocostaarma at sapo.pt>

>  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.
>
>
>
>
> Em 13-06-2012 14:46, José María Amuedo escreveu:
>
> Hi,
>
> I would like to know how can import excel file to postgresql. I'm working
> with linux OS.
>
> Thanks
>
>
> _______________________________________________
> postgis-users mailing listpostgis-users at postgis.refractions.nethttp://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120613/5cf0b5b6/attachment.html>