Connection database with Excel and Autocad

[Madruga_SP]

I'm trying to link a text from Autocad to an excel spreadsheet so that when changed in Excel, be changed in autocad.

 

After searching on some forums, I started doing database through ODBC.

 

I made a table in excel selecting and naming fields, added the file in windows OBDC manager, able to make the connection through dbConnect autocad, created label ...

 

 

Now I need to put the information in the database autocad text entity and already there I'm not getting more done, could you give me a light?

 

Thank in advance.

Regards

[Madruga_SP]

Can Anybody help me out, please!

Edited April 3, 2013 by Madruga_SP

[mostafa badran]

you can use PASTESPEC command from edit menu select the cell in excel sheet an pres ctrl + c then go to auto cad and use PASTESPEC command like attachment Is this what you want

sorry to my bad English

 

 

[Madruga_SP]

Hi,

Thanks for replay mostafa badran

 

I've tried doing that but no success.

I was wondering if have possible other way.

Regards

[mostafa badran]

can you Told me what s the problem in this way Exactly

 

However you can Look to this video ......

 

 

Edited April 4, 2013 by mostafa badran

[Bill Tillman]

That you tube video is so small on my phone and without narration it appears they are just showing a copy and paste method. But what it sounds like you want is a DataLink. This will allow changes in the Excel file to be updated in the AutoCAD file and visa-versa.

 

Just do a search or look in AutoCAD help for datalink. I think you will find what you're looking for.

[Deeboyd5010]

I have been using data Links. They work okay, but if the excel files gets to big it tends to slow down when connecting the tables to CAD. Once connected they work great. I hope that helps.