Pipe Data in Excel database connection with pipe data in civil 3D?????

[Anonymous]

Lot of modification in the pipe data.

Working with excel for modifying the values will be a lot helpful. Is there any way I can connect or manage this large amount of data in excel and transfer the data to the pipe network in the dwg file?

Any option will be helpful.

Thanks a lot...

[tcorey]

How are your programming skills? You could do this with VB.NET or C#.

[Habib_Nespak]

sir 

i am facing the same problem. and i have no skill to do work in VBA so if you have any way to transformation of data from excel to civil 3d or civil 3d to excel please let me know.

i shall be very thankful to you

[Jeff_M]

There is a sample VBA program which comes with C3D. Look in the folder (adjust accordingly for the version you are using) C:\Program Files\Autodesk\AutoCAD Civil 3D 2013\Sample\Civil 3D API\COM\Vba\Pipe . You will need to unstall the VBA extension if not already installed. The sample VBA has 4 commands, 2 of which may be helpful to you: 

ImportFromExcel - Import Pipes and Structures' data from a Excel file
to the current drawing.

ExportToExcel - Export Pipes and Structures' data in a current drawing
to a Excel file.

[Habib_Nespak]

sir 

i tried but failed so please expain me a little more to resolve my problem

thanks

regard