[Gvsig_english] Add on OLE Driver to have an access by ODBC toadatabase

[Juan Lucas Dominguez Rubio]

Hello, Alphonse
 
Sorry, I didn't realize that it is actually possible to connect to an Excel file from gvSIG. I have done it using always lower case for the names:
 
I have a file called excel_file.xls with a sheet called sheet1 and I have created an ODBC item called excel_odbc in the 'Administration tools' section of the Windows Control panel.
 
In gvSIG, I have used the 'Table - New - Database' option, and the parameters are:
 
Database: excel_odbc
Table: [sheet1$]
(All other parameters empty)
 
The name of the table is the name of the sheet with the dollar symbol and between brackets. If you sheet is called foo, the table name will be [foo$]
 
In this way, you can add an Excel file to your gvSIG project as a table.
 
Regards,
 
 
Juan Lucas Domínguez Rubio
Prodevelop SL, Valencia (España)
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/> 

________________________________

De: gvsig_internacional-bounces at runas.cap.gva.es en nombre de Alphonse CARLIER
Enviado el: mar 03/06/2008 15:17
Para: Users and Developers mailing list
Asunto: Re: [Gvsig_english] Add on OLE Driver to have an access by ODBC toadatabase


Hello,

Ok I saw a tutorial (in french) about this, to convert an xls file into dbf. I try to join tables and it is working.

But there is a tempate to use connect to odbc so  it is no active...

Thanks for your reply and support.

Alphonse

Juan Lucas Dominguez Rubio a écrit : 

	Hello, Alphonse
	 
	I think it's not possible to do that currently in gvSIG. I think it would not be difficult to write a gvSIG plugin to create a connection that would access your Excel files using the sun.jdbc.odbc package.
	 
	So far, the only way I can think of is saving your Excel sheets as DBF files and adding them to your gvSIG project with the "Table - New - File - Add" option.
	 
	Regards,
	 
	Juan Lucas Domínguez Rubio
	Prodevelop SL, Valencia (España)
	Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
	http://www.prodevelop.es <http://www.prodevelop.es/> 

________________________________

	De: gvsig_internacional-bounces at runas.cap.gva.es en nombre de Alphonse CARLIER
	Enviado el: jue 29/05/2008 14:23
	Para: gvsig_internacional at runas.cap.gva.es
	Asunto: [Gvsig_english] Add on OLE Driver to have an access by ODBC to adatabase
	
	

	Good afternoon,
	
	I would like to meke and access by ODBC  (to an excel file)
	
	I define a such connexion on my PC, but when I click on geograph layer,
	I have POSGIS or HQLDB or mySQL JDBC
	
	I wonder how I could installe this driver with gvSIG.
	
	Thanks you
	
	Alphonse
	_______________________________________________
	Gvsig_internacional mailing list
	Gvsig_internacional at runas.cap.gva.es
	http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
	

	
________________________________


	_______________________________________________
	Gvsig_internacional mailing list
	Gvsig_internacional at runas.cap.gva.es
	http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
	  


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20080603/5ea4246d/attachment.htm