Populating attributes or fields from an Excel Spread sheet

Populating attributes or fields from an Excel Spread sheet

tgoodson
Explorer Explorer
1,428 Views
2 Replies
Message 1 of 3

Populating attributes or fields from an Excel Spread sheet

tgoodson
Explorer
Explorer

We have an Excel Spread sheet that lists our Sales Force with their location, Branch Manager and Reg. Manager. I want to know is there a way in my drawing to input the Sales Rep. and the other information gets populate by looking at the excel spread sheet. We have a trasmittal sheet in our drawing that this information is on, either attributes or fields.

 

 Capture 1.JPG

 

 

Capture2.JPG

0 Likes
Accepted solutions (1)
1,429 Views
2 Replies
Replies (2)
Message 2 of 3

john.vellek
Alumni
Alumni
Accepted solution

Hi @tgoodson,

 

I ran across this older post and was curious if you ever got an answer to your question.

 

AutoCAD does not have a feature to link fields or attributes to Excel. However, you can connect objects to a database such as an Access database. Here is an AKN Article that walks through the process. If this looks like something you want to pursue, the Excel data can easily be imported into Access as a table.

 

Please hit the Accept as Solution button if my post fully solves your issue or answers your question.

 

 


John Vellek


Join the Autodesk Customer Council - Interact with developers, provide feedback on current and future software releases, and beta test the latest software!

Autodesk Knowledge Network | Autodesk Account | Product Feedback
0 Likes
Message 3 of 3

tgoodson
Explorer
Explorer

John,

 

No has not been answered. It may be the correect answer and clear to you but not clear to me.

 

The information we have in Excel can easly be put into Access. 

 

So I would like to be able to put in my drawing the Sales Rep name and all the other information for that sales rep be populated from the database.

 

I also would like to take this information and other from the title block and create a new Database file with that Infromation.

 

This link may help describe what I’m trying to do.

 

http://forums.augi.com/showthread.php?71316-Populate-title-block-fields-with-Access-DB-values-AutoCA...

 

Thanks for your help.

 

Todd

0 Likes