[Gvsig_english] GvSig connection to Access Database

Mario Carrera mcarrera at gvsig.com
Mon Jun 4 13:13:51 CEST 2018


Hello Sara,

the current Java version, Java 8, that is included in gvSIG, doesn't 
support ODBC connections. In that way it was possible to connect to 
Access databases, but it's not possible now. If there's an entity 
interested in financing that development it would be done.

In addition, there's a way to load the data from the table in gvSIG, 
that is exporting to DBF or CSV files previously. They can be added as a 
point layer in gvSIG, using the coordinates of the table.

There are two ways:

1. Event layer: Here you can see how to do it: 
https://blog.gvsig.org/2018/02/01/gis-applied-to-municipality-management-module-8-2-creation-of-point-layers-from-tables-event-layers/ 

You can export the event layer to shapefile later.

2. Adding the table as layer: For that you can access to "Add layer", 
then from the "File" tab you select the CSV or DBF file, and you access 
to the "Properties" button. At the "Geometry" tab you can select the 
fields with X and Y coordinates. Here you have a video about that (it's 
in Spanish but it will be useful to find the menus):
https://youtu.be/SzIm7daWQsg?t=362
You can export the CSV or DBF layer to shapefile later.

The DBF file can be edited later from gvSIG directly, and you can edit 
its alphanumerical information.

If you export it to shapefile you can edit it too. Here you can see how 
to do it
https://youtu.be/obKRB3flUlM?t=338

Best regards,
   Mario





El 04/06/18 a las 11:42, Sara Tagaduan escribió:
> To whom it may concern,
>
> I am currently working on a project in gvSig and I am having some 
> difficulties in establishing a link between the program and a Access 
> Database. The Access file contains fields as "Site name", "Site type", 
> "Monument type" and UTM Coordinates. For every site I need a point 
> introduced at the corresponding coordinates, and the site name, type 
> and monument type as attributes.
>
> Is there any way I can import the information in gvSig as a table 
> without having to introduce every bit of information manually? And if 
> so, could the program update the table automatically when new 
> information is inserted in the Access file? If gvSig does not support 
> a connection with Access, what would be the best solution for my problem?
>
> Thank you in advance.
>
> Best regards,
> Sara
>
>
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional en listserv.gva.es
>
> To see the archives, edit your preferences or unsubscribe from this mailing list, please access this url:
>
> https://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional

-- 

*Mario Carrera*

Training, Language and Communication Manager. gvSIG Association

Responsable de Formación, Internacionalización y Difusión. Asociación gvSIG

http://www.gvsig.com <http://www.gvsig.com/>

------------ pr�xima parte ------------
Se ha borrado un adjunto en formato HTML...
URL: <http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20180604/45bf124e/attachment.html>


More information about the Gvsig_internacional mailing list