CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Threaded View

  1. February 17th, 2008, 06:36 AM #1
    Lim Say Kiap
    Lim Say Kiap is offline Member
    Join Date
    Jan 2001
    Location
    Singapore
    Posts
    200

    Problem using CColumn of Jet OLE DB 4.0 on Excel Spreadsheet

    I am using OLE DB to read excel spreadsheet. After connection has been made, and a worksheet has been specified by calling the CColumn::Open(), I would use the CColumn::MoveFirst() and and CColumn::MoveNext()to retrieve the all the columns information of a the selected worksheet.

    This works perfectly fine for normal worksheets. However for worksheets that have names starting with numeric (eg 1Sheet1) or has a dash (eg Sheet-1) in the name, the CColumn::MoveFirst() returns DB_S_ENDOFROWSET. Does anyone knows what is the problem?

    Thanks.
    Last edited by Lim Say Kiap; February 20th, 2008 at 03:45 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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




Click Here to Expand Forum to Full Width

Featured