I obtened this error:<br><br>RROR: extra data after last expected column<br>SQL state: 22P04<br>Context: COPY nueva, line 1: "CODIGO;TIPO;DESCRIPCION;REPRESENTACION;PERFIL;CLAVE;VER3D;CARACBUSQ;LETRA;CAPITULO;SUBCAPITULO;ESTA;..."<br>
<br><div class="gmail_quote">2012/6/13 Pedro Costa <span dir="ltr"><<a href="mailto:pedrocostaarma@sapo.pt" target="_blank">pedrocostaarma@sapo.pt</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hi José,<br>
<br>
You have to convert the excel file to csv and use the copy command
like that:<br>
<br>
<br>
copy table_name from 'C:\Users\TEMP\filename.csv' WITH CSV
DELIMITER ';';<br>
<br>
<br>
You have to create the table before and delete the column names of
csv file.<br>
<br>
<br>
<br>
<br>
Em 13-06-2012 14:46, José María Amuedo escreveu:<br>
</div>
<blockquote type="cite"><div class="im">Hi,<br>
<br>
I would like to know how can import excel file to postgresql. I'm
working with linux OS.<br>
<br>
Thanks<br>
<br>
<fieldset></fieldset>
<br>
</div><pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
<br>
</div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br>