Jump to content
SolaR123

From Excel to AutoCAD

Recommended Posts

SolaR123

I've found a number of articles outlining the process of extracting data from AutoCAD to an Excel file, but I'm wondering if it's possible to do the reverse. For my work I have a number of databased already established in Excel and am able to create information tables rather quickly that access these databases. Currently, after creating a table in Excel I then copy, paste, scale to the right size in AutoCAD.

 

There's gotta be a way to create a table in AutoCAD that simply accesses this information in Excel and just updates automatically. I produce a number of CAD drawings off of a template daily so this process has become quite the bottleneck.

 

I really appreciate any help!

Share this post


Link to post
Share on other sites
ReMark

AutoCAD LT? Hmmm....not sure but I know in full AutoCAD one can use a DataLink. The information in the spreadsheet (not sure why you keep referring to databases) can be updated either from within Excel or from within AutoCAD.

Share this post


Link to post
Share on other sites
BlackBox

@Remark - I *believe* the OP is using the term 'database', in the context that data is stored in that particular 'repository', generally speaking.

 

@SolaR123 - Have tried using GetExcel.lsp?

Share this post


Link to post
Share on other sites
ReMark

Renderman: LT cannot utilize a lisp routine.

Share this post


Link to post
Share on other sites
SolaR123

@RederMan - correct about my intent. I store all needed information in 'databases' on different worksheet. I access that information which creates tables. I need to import those tables into AutoCAD and copy/paste is getting old.

 

@ReMark - Thank you! you pointed me in the right direction. I created a table of just a single cell. Right click the cell and set up a DataLink. From that, I link the table I need in Excel and it 'imports' the entire table into that one cell (scaling is now just a one-time issue). After making changes to the table in Excel, I right click the table in AutoCAD and update it. It's a beautiful thing.

 

Thank You!

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...