vanslayer Posted December 21, 2011 Share Posted December 21, 2011 Hello I have a table in excel and I'd like to have text in cells link to nodes on a map. i.e. I have the traffic volume of a road section in a table. I'd like to show that volume on a map beside a circle where the count was taken. I'd like to be able to update the table value and have it also update on ythe map. Any suggestions? Any help would be appreciated. Thanks Quote Link to comment Share on other sites More sharing options...
tzframpton Posted December 21, 2011 Share Posted December 21, 2011 DATALINK is the command you'll want to go with initially, although that will only get the Excel file into CAD. As far as the linking, you might be in need of a customized program for that. Quote Link to comment Share on other sites More sharing options...
Murph_map Posted December 21, 2011 Share Posted December 21, 2011 With LDT 2005? You should have tools in there that will do it with the DBConnect commands. Quote Link to comment Share on other sites More sharing options...
ScribbleJ Posted December 21, 2011 Share Posted December 21, 2011 Use the command TABLE: Then use the area highlighted and encompassed in red in the image below. This method works perfectly. I have not had any issues with it at all. If you currently have the drawing open and the changes made in your Excel file do not update dynamically then you will have to do a datalink refresh which is located in the lower right of your AutoCad interface. Quote Link to comment Share on other sites More sharing options...
Murph_map Posted December 22, 2011 Share Posted December 22, 2011 Use the command TABLE:Then use the area highlighted and encompassed in red in the image below. This method works perfectly. I have not had any issues with it at all. If you currently have the drawing open and the changes made in your Excel file do not update dynamically then you will have to do a datalink refresh which is located in the lower right of your AutoCad interface. Unless the OP hasn't updated his profile since he/she posted their first post it shows as using 2005 version, which doesn't have the "Table" tools they are out of luck unless they learn the map data links and DBconnect. Quote Link to comment Share on other sites More sharing options...
vanslayer Posted December 28, 2011 Author Share Posted December 28, 2011 Hello All Thanks for replying. I have changed my profile to 3d 2010. I managed to get the excel table linked to a table in CAD (thanks). How do I then link those values in the tables to a circle or marker on a map? I'd like to place a marker on street on a map and have it show the volume from the table. I'd also like the map volume to change with the table. Hope everyone is enjoying their holidays Thanks, Quote Link to comment Share on other sites More sharing options...
Murph_map Posted December 28, 2011 Share Posted December 28, 2011 OK so you want to select a point/marker and have it display the record from your table. Then when you edit the table in Excell your dwg updates as well. Then you need to use the MAP3D datasource tools that's are part of Civil3D. The "table" object are lacking in this. Doest your table have any coordinate (X,Y,Z) data in it? What OS and 32/64 bit and what version of Excel (Ms Office). Any chance you can convert the spreadsheet into a Database format? Take a look at the MAPATTACHDB command and the tutorials on database connections. Quote Link to comment Share on other sites More sharing options...
Organic Posted December 29, 2011 Share Posted December 29, 2011 I am interested in this also. Quote Link to comment Share on other sites More sharing options...
Murph_map Posted December 29, 2011 Share Posted December 29, 2011 Dink, I got two skiboats (inboards) that need working on, one needs new head caskets the other has a drive line issue. Good thing its too cold to go water sking for the next few months. Looks like i need to start taking the laptop into the shop to get back to blogging on lunch breaks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.