See the top rated post in this thread. Click here

Results 1 to 4 of 4

Thread: Importing data from Excel Spreadsheet

  1. #1
    Member
    Join Date
    2013-04
    Posts
    6
    Login to Give a bone
    0

    Post Importing data from Excel Spreadsheet

    Hi all,

    I have a co-worker here who would like to have a drawing of our campus map that contains the location of all the light poles on campus. What he would like to see is something along the lines of being able to click on the light and have something like a quick properties box that contains all the information he needs about that light. The closest I have been able to do is to have a "semi-dynamic" table that can be imported to the drawing (needs to be manually refreshed whenever there is a change) as well as a simple hyperlink that opens the entire spreadsheet rather than the specific row. Right now, the worst case is that he has do some cross-referencing on that light (which is about 100 lights) but would prefer the single row "quick properties" idea. I've heard that for something like this, Map3D is the way to go...but I'm not sure how to go about that.

    Thanks for all the help,
    -Bethel CAD

  2. #2
    Geospatial Moderator Jmurphy's Avatar
    Join Date
    2000-11
    Location
    TN/KY Area
    Posts
    1,640
    Login to Give a bone
    0

    Default Re: Importing data from Excel Spreadsheet

    Yes Map3D can do what you want. One way is by using Object Data tables to hold the data That data can then be viewed in the property palette. Another way is to convert the light poles to a SDF format file and use data connect to bring it into your map. This way there is a table that contains all the data of the lights and when selecting the lights it will highlight the record in the table.
    J. Murphy
    AKA
    Murph
    The former AutoCAD MAP3D Power User

  3. #3
    Member
    Join Date
    2013-04
    Posts
    6
    Login to Give a bone
    0

    Default Re: Importing data from Excel Spreadsheet

    I've never really tried using Object Data tables before in MAP...once I create one like this tutorial says, what would I do from there?

  4. #4
    Geospatial Moderator Jmurphy's Avatar
    Join Date
    2000-11
    Location
    TN/KY Area
    Posts
    1,640
    Login to Give a bone
    2

    Default Re: Importing data from Excel Spreadsheet

    After you create the Table use the adeattachdata command and select one of the lights in the dwg, then just fill in the fields for that light. (Make sure you press the ENTER key after each field and not the tab key).
    Once you attach the data to an object click on it and look in the property palette, that info is there at the bottom. Also you can use that data to style the lights for example all Mercury Vapor to be red in color and all Soduim lights to b blue in color. The style can be seperate from the autocad layers the objects reside on. There's a lot you can do with the object data once you have it created.
    J. Murphy
    AKA
    Murph
    The former AutoCAD MAP3D Power User

Similar Threads

  1. Importing data from an Excel spreadsheet
    By spacepig62 in forum AutoLISP
    Replies: 25
    Last Post: 2012-09-13, 03:48 PM
  2. Can't connect data table to excel spreadsheet
    By glenn22 in forum AutoCAD Map 3D - Data Connect (FDO)
    Replies: 7
    Last Post: 2010-05-18, 03:16 PM
  3. Importing spreadsheet data into AutoCAD Electrical 2005
    By hinschberger in forum AutoCAD Electrical - General
    Replies: 2
    Last Post: 2007-05-25, 07:35 PM
  4. Replies: 2
    Last Post: 2007-04-12, 11:40 AM
  5. Importing Excel Spreadsheet/Tables
    By mbazso in forum ATP Course Wishlist
    Replies: 1
    Last Post: 2006-01-27, 02:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •