Welcome to the CADTutor forums, probably the most lively and friendly AutoCAD forums on the web. You will need to register in order to post a question and to see all the content on this board. See How to register for details. Use the Lost password recovery form if you ever forget either your password or username. Be sure to check out the FAQ for more information.

Excel Database and AutCAD

Registered forum members do not see this ad.

Good day,

This is my first post after hours of searching. I have bits and pieces related to my question, but nothing substantial. I have a database with ~350 computer's physical coordinates within the building (actually not yet, but a field to fill) and all related info for that computer. Is it possible to have an object for each computer, and have that object's coordinates within the drawing updated when the database is updated? Or anything that can help with IT's management of these assets? The long-term goal is to have the maintenace people to be able to see where an asset(computer) is physically within the building. We will soon be using HP Service Manager 7 which utilizes a database with said information. I apologize if this is in the wrong thread. I have only fiddled with AutoCAD and am now jumping in head-first. I have only about 30 days to figure this out. Thanks!!! (patience with the Noob )

"You would need 2 VBA apps:
1. From AutoCAD open and update Excel or a direct update of a csv file.
2. From Excel open and update Autocad or use Open Design software.

If it is just block refs this should be fairly easy if the block name is unique or you save the object handle in excel. WARNING: If a drawing has to be recovered the handle could change or the block name could change!!

This is why my blocks have a Record Number Attribute that is unique for each block insertion."

"You would need 2 VBA apps:
1. From AutoCAD open and update Excel or a direct update of a csv file.
2. From Excel open and update Autocad or use Open Design software.

If it is just block refs this should be fairly easy if the block name is unique or you save the object handle in excel. WARNING: If a drawing has to be recovered the handle could change or the block name could change!!

This is why my blocks have a Record Number Attribute that is unique for each block insertion."

Sound correct? But I'm not that good at code(VBA).

I would forget about the VBA stuff it may not be around long. I also would not suggest Excel as it's not a database for records. Now either look at the DBConnect commands in AutoCAD or a good Facility Management application. I have done demos on what you are wanting but with AutoCAD MAP3D and databases.

i have link my excel spreadsheet to atuocad object, but my problem is that i cannot update my excel file from within autocad. the excel file is opened in
READ ONLY mode in dbconnect data view window.how can i changed to edit mode

Murph_map's Computer Details

Murph_map's Discipline Details

Occupation

Boats and campers renting and repairs

Discipline

Utilities

Details

GIS and Map making.

Using

Map 3D 2016

Join Date

Feb 2011

Location

TN or KY depends if I'm at work or home.

Posts

924

In Excel yoiu need to save the file(s) spreadsheets as a shared file. Depending on what version of MS Office as to how, google it or check in the help for the correct way. Then reopen AutoCAD and make the connections.

In Excel yoiu need to save the file(s) spreadsheets as a shared file. Depending on what version of MS Office as to how, google it or check in the help for the correct way. Then reopen AutoCAD and make the connections.

i tried it but again the same thing i.e the excel spredsheet open in read only mode. i am using ms office 2010 64bit and autocad 2010 64bit. also i am using the DBCONNECT MANAGER to link my excel spreadsheet to my drawing object, for which i need to edit the excel table from within autocad.

i tried it but again the same thing i.e the excel spredsheet open in read only mode. i am using ms office 2010 64bit and autocad 2010 64bit. also i am using the DBCONNECT MANAGER to link my excel spreadsheet to my drawing object, for which i need to edit the excel table from within autocad.

When you use the ODBC Data Source Administrator make sure you check that read only is not checked.