Results 1 to 3 of 3

Thread: Connection database with Excel and Autocad

  1. #1
    Member
    Join Date
    2009-01
    Posts
    37
    0 Did you find this post helpful? Yes

    Default Connection database with Excel and Autocad

    Good evening,

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

    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, can someone give me a light?

    Thank you!

  2. #2
    Member
    Join Date
    2009-01
    Posts
    37
    0 Did you find this post helpful? Yes

    Default Re: Connection database with Excel and Autocad

    The idea is this: I will work with the same stamp that will be inserted in the various plants through xref. so if I have 10 plants and need to change something I'll need to change the stamp only on the base.

    The texts containing information which change according to plant such number of plank, plank content, scale, reviews, artist name, name of the designer, etc.. these will be organized in excel as a table and serve as the basis for the text on the stamp autocad.

    If the stamp is on board 1 layout data corresponding excel vai pair of stamp, if the board layout 2 the same thing and so on.

    So the idea of doing this using Excel as a database and the corresponding texts in autocad thus need only to move the information in excel without opening all plants.

    I can link to the excel table via ODBC and using dbConnect in autocad, but I am not knowing how to text or mtext cad get the information from the database table

  3. #3
    Member
    Join Date
    2008-02
    Posts
    35
    0 Did you find this post helpful? Yes

    Default Re: Connection database with Excel and Autocad

    Quote Originally Posted by luislhss View Post
    The idea is this: I will work with the same stamp that will be inserted in the various plants through xref. so if I have 10 plants and need to change something I'll need to change the stamp only on the base.

    The texts containing information which change according to plant such number of plank, plank content, scale, reviews, artist name, name of the designer, etc.. these will be organized in excel as a table and serve as the basis for the text on the stamp autocad.

    If the stamp is on board 1 layout data corresponding excel vai pair of stamp, if the board layout 2 the same thing and so on.

    So the idea of doing this using Excel as a database and the corresponding texts in autocad thus need only to move the information in excel without opening all plants.

    I can link to the excel table via ODBC and using dbConnect in autocad, but I am not knowing how to text or mtext cad get the information from the database table
    Hi,
    In my opinion you could create more simply a block with attributes and change the attributes reading a text file or excel file as you prefer by a very poor macro in VBA.

    If you can send me a sample stamp I'll try to write a code for you.

    Regards

Similar Threads

  1. AutoCAD 2011 and creating in database connection
    By svest in forum AutoCAD Map 3D - Data Connect (FDO)
    Replies: 0
    Last Post: 2010-09-24, 01:33 PM
  2. C3D Table connection with Excel
    By Civil 3D Wishes in forum Civil 3D Wish List
    Replies: 0
    Last Post: 2008-05-01, 08:53 PM
  3. Excel connection
    By cll in forum VBA/COM Interop
    Replies: 7
    Last Post: 2006-10-27, 02:01 PM
  4. connection to sql database
    By sdickson in forum AutoCAD Customization
    Replies: 3
    Last Post: 2005-08-04, 11:30 AM
  5. Database Connection to SQL Server
    By dasmith in forum AutoCAD Map 3D - General
    Replies: 1
    Last Post: 2005-02-02, 09:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •