Jump to content
jmsimpson

importing data from excel into AutoCAD 2011 Map 3D

Recommended Posts

jmsimpson

I have an excel file with several thousand lines of data and they all have UTM coordinates attached to them. I would like to have the data mapped out as points once imported. Is there a way to import this data into AutoCAD without going through ODBC? I have also imported the data into Access so retrieving the data from there is possible as well.

Share this post


Link to post
Share on other sites
jmsimpson

Also, once I get the data into AutoCAD, I would like to merge it (if that is the correct AutoCAD term) with some shapefiles I have already imported into AutoCAD. Any advice will be of help. Thanks!

Share this post


Link to post
Share on other sites
Murph_map
I have an excel file with several thousand lines of data and they all have UTM coordinates attached to them. I would like to have the data mapped out as points once imported. Is there a way to import this data into AutoCAD without going through ODBC? I have also imported the data into Access so retrieving the data from there is possible as well.

 

A number of ways may work. What data is in the files as far as attributes or fields that you want to carry over? Are you just wanting points at the x&Y locations or data attached to them. Save the excel file to txt or CSV format and use the mapimport command and select the ACSII Point file format.

Share this post


Link to post
Share on other sites
jmsimpson
A number of ways may work. What data is in the files as far as attributes or fields that you want to carry over? Are you just wanting points at the x&Y locations or data attached to them. Save the excel file to txt or CSV format and use the mapimport command and select the ACSII Point file format.

 

I would like to plot the excel points and associated data from the file to the points. It's more complicated for my case because I am unable to use an ODBC connection. I've tried importing the data as an ASCII file and it hasn't worked.

Share this post


Link to post
Share on other sites
Murph_map
I would like to plot the excel points and associated data from the file to the points. It's more complicated for my case because I am unable to use an ODBC connection. I've tried importing the data as an ASCII file and it hasn't worked.

 

Right ODBC doesn't work with Excel files in 2011, Access or SQL does. Can you post the first few records (rows) of the data you need to import? Also are you using Civil3D (this is the C3D forum)

Share this post


Link to post
Share on other sites
jmsimpson

Hi Murph,

 

Here are a few lines of my data. As far as description goes, is there anyway to inject more than one criteria of description into the inputed data?

 

Point UTMe UTMn Z Desc

15-0288 4187600.24 251578.12 0 ABCO

23-0807 4187755.37 251742.63 0 ABCO

28-0055 4187470.64 251826.78 0 ABCO

29-0015 4187463.77 251834.07 0 ABCO

 

Thanks for your input!

Edited by jmsimpson
formatting was wonky

Share this post


Link to post
Share on other sites
SLW210

Is there a reason you have decided to create a second post?

 

I merged and cleaned up the two threads. Next time just request to have it moved. It is less confusing for those that answer your question.:thumbsup:

Edited by SLW210

Share this post


Link to post
Share on other sites
Murph_map
Hi Murph,

 

Here are a few lines of my data. As far as description goes, is there anyway to inject more than one criteria of description into the inputed data?

 

Point UTMe UTMn Z Desc

15-0288 4187600.24 251578.12 0 ABCO

23-0807 4187755.37 251742.63 0 ABCO

28-0055 4187470.64 251826.78 0 ABCO

29-0015 4187463.77 251834.07 0 ABCO

 

Thanks for your input!

 

If you delete the first line (Point, UTMe, etc) and use PENZD Space Delimited your points insert OK. Check the coordinate system and then you may have to scale the blocks used for the point marker after the import.

Share this post


Link to post
Share on other sites
jmsimpson

Murph,

 

That kind of worked. What I need to do now is make the points smaller. Why is each point represented by a large crosshair and how can I reduce the size of the font and the crosshair so my thousands of points are readable.

 

Thanks for the help

Share this post


Link to post
Share on other sites
Murph_map

The crosshairs and text are the blocks that it uses to bring the points in. You can select them all (or use Quick Select and select all blocks named Map_survey_point) then in the property palette set the X,Y,Z scale to a smaller number.

Share this post


Link to post
Share on other sites
jmsimpson

Thanks for your help, Murph. I am slowly accomplishing what I set out to do in AutoCAD!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...