[Gdal-dev] ogr virtual data issues with connecting to excel

[Normand Savard]

Tom,

You could verify your connection with the Excel driver by using this 
small application:  ODBCView:

http://asia.cnet.com/downloads/pc/swinfo/0,39000587,39034753s,00.htm


Norm

Kralidis,Tom [Burlington] wrote:

>Hi,
>
>I'm trying to connect to an excel document using this approach, but am
>having problems doing so.
>
>I have created a system DSN
>
>Here is my .ovf file:
>
><OGRVRTDataSource>
>	<OGRVRTLayer name="plantwatch">
>		<SrcDataSource>ODBC:plantwatch2,plantwatch</SrcDataSource>
>		<SrcLayer>plantwatch</SrcLayer>
>		<GeometryType>wkbPoint</GeometryType>
>		<LayerSRS>WGS84</LayerSRS>
>		<GeometryField encoding="PointFromColumns" x="longitude"
>y="latitude"/> 
>	</OGRVRTLayer>
></OGRVRTDataSource>
>
>When I test with ogrinfo, I get:
>
>C:\ms4w\Apache\cgi-bin\ms_odbc>.\ogrinfo.exe
>\ms4w\mapserv\services\naturewatch\plantwatch2.ovf
>ERROR 4: Update access not supported for VRT datasources.
>ERROR 1: Unable to identify source X or Y field for PointFromColumns
>encoding.
>FAILURE:
>
>Any suggestions?  The x and y attributes exist as columns in my excel file.
>As a workaround, when I converted the excel file to an access database, it
>worked.
>
>I can post the excel document on request.
>
>Thanks
>
>..Tom
>
>=========================
>Tom Kralidis
>Systems Scientist
>Environment Canada
>Tel: +01-905-336-4409
>http://www.ec.gc.ca/cise/
>_______________________________________________
>Gdal-dev mailing list
>Gdal-dev at remotesensing.org
>http://remotesensing.org/mailman/listinfo/gdal-dev
>
>  
>