CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
+ Reply to Thread
Results 1 to 4 of 4
  1. June 6th, 2012 08:38 AM #1
    links
    links is offline Member links is an unknown quantity at this point (<10)
    Join Date
    Apr 2007
    Location
    South Africa
    Posts
    86

    COM/OLE Automation - Excel

    Access 2003 can export a table to Excel (newer versions can probably do the same).

    How do they do it? Do they use COM Automation?
    Reply With Quote Reply With Quote
  2. June 6th, 2012 12:36 PM #2
    VictorN's Avatar
    VictorN
    VictorN is offline Elite Member Power Poster VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+)
    Join Date
    Jan 2003
    Location
    Wallisellen (Zürich), Switzerland
    Posts
    16,179

    Re: COM/OLE Automation - Excel

    I don't believe they use Automation to export data. I guess it would be much faster when using ISAM drivers for MS Excel.
    The same way they export data into text file (using ISAM drivers for text files)
    Victor Nijegorodov
    Reply With Quote Reply With Quote
  3. June 7th, 2012 04:55 AM #3
    links
    links is offline Member links is an unknown quantity at this point (<10)
    Join Date
    Apr 2007
    Location
    South Africa
    Posts
    86

    Re: COM/OLE Automation - Excel

    Thanks for your reply. First time I've heard of ISAM! Sounds like something I need so I can create formatted XLS files.

    Is there documentation available for this ISAM driver for Excel?
    Reply With Quote Reply With Quote
  4. June 7th, 2012 05:30 AM #4
    VictorN's Avatar
    VictorN
    VictorN is offline Elite Member Power Poster VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+)
    Join Date
    Jan 2003
    Location
    Wallisellen (Zürich), Switzerland
    Posts
    16,179

    Re: COM/OLE Automation - Excel

    It is not so complicated. You just need to properly set the connection string for Excel sheet where you will export your data.
    Accessing Data with ADO
    Connection strings for Excel 2007
    Connection strings for Excel
    Victor Nijegorodov
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules


HTML5 Development Center

Click Here to Expand Forum to Full Width