Import data from MS Excel into a drawing

[Jack Cheong]

We know want to list all attributes in the drawing into MS Excel table can use Attributes Extraction
But, how abt in the opposite way by import data from MS Excel into AutoCAD drawing, is it possible?
Any body can help me in this matter?

[Mike.Perry]

Hi

For starters, take a look at the links offered in THIS post...

Depending on exactly what you want to do with the data from Excel once it is in AutoCAD, you could also look at OLE and AutoCAD Tables.

Have a good one, Mike

[Jack Cheong]

Hi

For starters, take a look at the links offered in THIS post...

Depending on exactly what you want to do with the data from Excel once it is in AutoCAD, you could also look at OLE and AutoCAD Tables.

Have a good one, Mike

Thx for the adv, Perry
I want the data in Excel table to be attributes in AutoCAD drawing, is it possible?
thx n rgds

Jack Cheong

[rkmcswain]

Thx for the adv, Perry
I want the data in Excel table to be attributes in AutoCAD drawing, is it possible?
thx n rgds

Jack Cheong

Not enough details to know if this will work, but you can give it a look and/or contact the author. AutoCELL

[Jack Cheong]

Not enough details to know if this will work, but you can give it a look and/or contact the author. AutoCELL

Thx! It work w/o any 3rd party software

Jack Cheong

[Jack Cheong]

Thx for the adv, Perry
I want the data in Excel table to be attributes in AutoCAD drawing, is it possible?
thx n rgds

Jack Cheong

I found the solution in AutoCAD Helps
1. Copy information in source document (MS EXcel),
2. Switch to AutoCAD drawing, Edit - Paste Special, select to paste a link, then insert the OLE object in the drawing
3. Back to the source document, change the information and save the file
4. Switch to AutoCAD drawing, the inserted OLE object change accordingly

Thx Mike, OLE work in that way

Jack Cheong

[rkmcswain]

I found the solution in AutoCAD Helps
1. Copy information in source document (MS EXcel),
2. Switch to AutoCAD drawing, Edit - Paste Special, select to paste a link, then insert the OLE object in the drawing
3. Back to the source document, change the information and save the file
4. Switch to AutoCAD drawing, the inserted OLE object change accordingly

Thx Mike, OLE work in that way

Jack Cheong

That's all fine, but that is not what you asked for here:

I want the data in Excel table to be attributes in AutoCAD drawing

When you get tired of dealing with all the OLE problems, post back for another solution.