[postgis-users] Import excel file to postgresql

[José María Amuedo]

this is my file

2012/6/13 Pedro Costa <pedrocostaarma at sapo.pt>

>  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
>
>
>
>
> Em 13-06-2012 15:34, José María Amuedo escreveu:
>
> 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
>>
>>
>
>
> _______________________________________________
> 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/d533754a/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: elements.csv
Type: text/csv
Size: 34817 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120613/d533754a/attachment.csv>