Creating new point feature from xlsx database
Printed From: CAD Forum
Category: EN
Forum Name: Civil 3D, Map, InfraWorks
Forum Description: Discussion about mapping and GIS applications Map, Civil3D, InfraWorks, MapGuide and Raster Design
URL: https://www.cadforum.cz/forum_en/forum_posts.asp?TID=8916
Printed Date: 03.Jul.2026 at 00:35
Topic: Creating new point feature from xlsx database
Posted By: Guvo
Subject: Creating new point feature from xlsx database
Date Posted: 31.Jan.2013 at 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: 4861888431526230
Only 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?
|
|