davee37 Posted December 5, 2009 Share Posted December 5, 2009 Hi there, Having got many useful tips from this forum I thought I should post my own query. For years we have been importing data manually from excel spreadsheets supplied by a client. The data is basically personnel, name, location, phone extension, desk number, job title etc. They supply the .xls and we copy across and update the attributes on the drawing and try and keep about 400 positions updated. Reading some of the posts here it seems we have got into a rut and are way behind the times and that data extraction is the way to go. ? Firstly Is it possible to link the xl spreadsheet so if we make changes to the drawing it updates the spreadsheet and vice versa. Secondly, if it is, can I keep all the information on the drawing rather than working with two programmes, possibly with hyperlinks?? We use AutoCAD 2008 and probably only about 10% of it ability If anyone can point me towards a tutorial that covers this sort of exercise I would be very grateful. Quote Link to comment Share on other sites More sharing options...
ReMark Posted December 5, 2009 Share Posted December 5, 2009 We are currently linking AutoCAD and Excel via DataLink and having good results. The information can be changed in the drawing or in the spreadsheet and the other application updated as required. Quote Link to comment Share on other sites More sharing options...
davee37 Posted December 6, 2009 Author Share Posted December 6, 2009 Hmm, I have managed to export the data to an xl file using eattext and if I command line datalink I can see a thumbnail of the updated info but I cant for the life of me work out how to link them together Quote Link to comment Share on other sites More sharing options...
ReMark Posted December 6, 2009 Share Posted December 6, 2009 This is how it's done. I've confirmed it using the exact same steps. http://www.thecadgeek.com/blog/2007/04/13/linking-excel-and-autocad-with-data-links/ Quote Link to comment Share on other sites More sharing options...
davee37 Posted December 7, 2009 Author Share Posted December 7, 2009 Thanks so much for the link, I shall follow the steps to the letter.........but I might be back Quote Link to comment Share on other sites More sharing options...
chulse Posted December 7, 2009 Share Posted December 7, 2009 We are currently linking AutoCAD and Excel via DataLink and having good results. The information can be changed in the drawing or in the spreadsheet and the other application updated as required. Not to hijack the thread, but how large are the excel files you were able to link? I have never been able to link my tree data tables without crashing - but they are usually 3+mb each. Quote Link to comment Share on other sites More sharing options...
ReMark Posted December 7, 2009 Share Posted December 7, 2009 All ours are quite small (around 15-25KB) in comparison to your files. If I can find a larger Excel file (3MB+) I'll try linking it to a test drawing to see what happens. Quote Link to comment Share on other sites More sharing options...
chulse Posted December 7, 2009 Share Posted December 7, 2009 All ours are quite small (around 15-25KB) in comparison to your files. If I can find a larger Excel file (3MB+) I'll try linking it to a test drawing to see what happens. Thanks Quote Link to comment Share on other sites More sharing options...
Sparky Posted December 7, 2009 Share Posted December 7, 2009 We are currently linking AutoCAD and Excel via DataLink and having good results. The information can be changed in the drawing or in the spreadsheet and the other application updated as required. Couldn't you also use object linking and embedding? Quote Link to comment Share on other sites More sharing options...
davee37 Posted December 7, 2009 Author Share Posted December 7, 2009 Not to hijack the thread, but how large are the excel files you were able to link? I have never been able to link my tree data tables without crashing - but they are usually 3+mb each. I have no idea, first I have to rebuild the drawing making all the attribute blocks, then export it, then see if I can modify the exported file and try to update the drawing from the xl file. All this for the first time. Think I'll go and lay down for a bit first... Quote Link to comment Share on other sites More sharing options...
chelsea1307 Posted December 7, 2009 Share Posted December 7, 2009 I understand the linking excel to autocad tables, but how to link to attributes? or is it possible to create a field that links to a table cell? 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.