Display full version of the post: Creating new point feature from xlsx database

Guvo
31.01.2013, 17:09
Here's a question about AutoCad Map:I connected to an excel-database (ODBC-connection) containing :- unique ID's- X coordinates (Netherlands RD)- Y coordinates (Netherlands RD)I added this data to map (with coordinate system Netherlands RD). Up until this point everything is fine. The point feature's are projected at the right coordinates (Also Netherlands RD coordinate system assigned in drawing).Now i create a new point feature in Map and check it in. When i close the drawing the Excel-database updates. However, the x/y coordinates he shows look like this :- X: 1182391749728890- Y: 4861888431526230Only the green part is right, the rest of the numbers are wrong.Now, when i have an Acces-database with the same content and perform the same actions as above the coordinates come out right (6 digits).I would like to keep my database in Excel..Can anyone resolve this?