access table to a sheet of excel?

Discussion in 'AutoCAD' started by media, Apr 28, 2004.

  1. media

    media Guest

    Hi,
    Is ther any body who can help me to find an autocad vba for converting
    the data of an access table to a sheet of excel?
    thanks
     
    media, Apr 28, 2004
    #1
  2. media

    Ed Jobe Guest

    Use Excel. Data>Get External Data>New Database Query
     
    Ed Jobe, Apr 28, 2004
    #2
  3. media

    media Guest

    I'm looking for a solution by AutoCAD VBA
    thanks
     
    media, Apr 28, 2004
    #3
  4. media

    Ed Jobe Guest

    You can do it programmatically from acad. Use xl's QueryTable object. Set its Recordset property using an ADO connection.
     
    Ed Jobe, Apr 28, 2004
    #4
  5. media

    media Guest

    don't you have an example of code?
    thanks


     
    media, Apr 28, 2004
    #5
  6. media

    Ed Jobe Guest

    Its already in Excel's help file, just look up the QueryTable object and click on the Example link.
     
    Ed Jobe, Apr 28, 2004
    #6
Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads

  1. How to add record to Access table through visual lisp activex (I need the VB ! operator)

  2. access to the BLOCK_RECORD table

  3. Access to model from Excel

  4. Macro - write info to Access table

  5. Modifying Label Template Breaking Link to Access Table

  6. AutoCAD Link with MS-Access/Excel

  7. Using Excel instead of Access as a database

Loading...