Re: [postgis-users] Import excel file to postgresql

Try with i sample attached. be sure that your table must have columns according to the file Em 13-06-2012 15:50, José María Amuedo escreveu: this is my file 2012/6/13 Pedro Costa > Send me a sample of your file. But you have to remove the last semicol

Re: [postgis-users] Import excel file to postgresql

this is my file 2012/6/13 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;33. > column1_r2;column2_r2;column3_r2;33. > > > > > Em 13-06-2012 15:34, José María Amuedo escreve

Re: [postgis-users] Import excel file to postgresql

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;33. column1_r2;column2_r2;column3_r2;33. Em 13-06-2012 15:34, José María Amuedo escreveu: I obtened this error: RROR: extra data after last exp

Re: [postgis-users] Import excel file to postgresql

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 > Hi José, > > You have to convert the excel file to c

Re: [postgis-users] Import excel file to postgresql

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 On Mittwoch 13 Juni 2012 15:46:20 José María Amuedo wrote: > Hi, > > I would like to know

Re: [postgis-users] Import excel file to postgresql

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/ Am 13.06.2012 15:46, schrieb José María Amuedo: Hi, I would like to know how can import excel file to

Re: [postgis-users] Import excel file to postgresql

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:

[postgis-users] Import excel file to postgresql

Hi, I would like to know how can import excel file to postgresql. I'm working with linux OS. Thanks ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users