I am trying to import points, which contain longitude and latitude data, to a geographic area (polygon) in ArcMap but they are not overlapping. I have added a point layer (.csv) to my table of contents and then a polygon that represents the geographic area of Sri Lanka.
When trying to export the points as an excel file it says that ' Failed to connect to the database. An underlying database error occurred. Class not registered'.
I have tried doing it the other way around, by first adding the country of Sri Lanka into the table of contents, first with and then without the .prj., then I inserted the points which contain latitude and longitude. After displaying XY data, the new layer does not contain the attribute information and again does not allow me to export it into a new layer. It says 'There was an error exporting the layer'. (The layer has no OID field. If this is the problem how can I add one?) When checking the coordinate system under data frame properties, both, points and polygon seem to have the same coordinate (Kandawaal_sri_Langa_Grid).