I would like to add xy coordinates of about 10 sites to a raster. I am using ArcGIS 10.1 and my xy coordinates are on Access 2013 database - saved as .mdb.
The steps I have taken so far:
1) In ArcCatalog - I tried making the OLE DB connection - Microsoft Jet 4.0. OlE Provider - when i clicked 'next' it says the connection is a 'success'
2) Then I clicked on the Database Connections on the arcCatalog tree, clicked on the 'OLE DB connection' and the table appears to be ok on the 'preview' screen. However when i click on the 'Description' section there is the error message: 'The item's XML contains errors' - I don't know what this means.
Anyways, I right clicked the table under OLE DB connection (on the arcCatalog tree) - clicked 'create feature class' - 'from XY'Table (i also put the right coordinate system - which is the British National Grid).
3) After that, I opened ArcMap. Added the DEM Raster (which also has the same coordinate system) and the XY feature class I just created.
But the problem is I cannot see the sites (the dots).
I have successfully done this in the past. But for some reason I just can't seem to get it to work this time. The following picture shows how I want it to appear:
I have also tried the other way: Arcmap - file - Add Data - Add XY data. And then right clicking the layer and clicking 'Data' - then 'Export data' to create a feature class.
A couple of weeks ago I did have a new version of Microsoft Access and excel installed ( the Microsoft office 2013 plus). I don't know whether this has something to do with it or whether I have simply missed a crucial step. If anyone could help me it would be massively appreciated!