COM/OLE Automation - Excel
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4

Thread: COM/OLE Automation - Excel

  1. #1
    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?

  2. #2
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Wallisellen (ZH), Switzerland
    Posts
    17,301

    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

  3. #3
    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?

  4. #4
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Wallisellen (ZH), Switzerland
    Posts
    17,301

    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

Posting Permissions

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


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center