Post reply

Exporting data to MS Ecel 2007 results in Error 0xc0202025: Data Flow Task 1: Cannot create an OLE DB accessor. Verify that the column metadata is valid

  • October 12, 2011 at 2:28 pm

    #249873

    Im trying to export data from 2 tables in my database:

    [prospects]

    and

    [prospectsincampaigns]

    But im getting an error (Error 0xc0202025: Data Flow Task 1: Cannot create an OLE DB accessor. Verify that the column metadata is valid.) and I dont know why:

    In MSSQL2008 I do the following:

    - right click on my db

    - tasks

    - export data...

    - source is yourba

    - next

    - destination is "Microsoft Excel"

    - filename is "c:\tmp\prospects.xlsx" (or for other table: "c:\tmp\prospectsincampaigns.xlsx")

    - set Excel version to Microsoft Excel 2007

    - Next

    - Next

    - Check [prospects]

    - Next

    - Next

    - Finish

    I see this error: Error 0xc0202025: Data Flow Task 1: Cannot create an OLE DB accessor. Verify that the column metadata is valid.

    The db backup can be found here: http://www.wunderwedding.com/files/yba_db.zip

  • October 12, 2011 at 2:37 pm

    #1393706

    Take a look at the Edit Mappings and tell me what the data types and sizes you are trying to export are.

    Thanks,

    Jared

    Jared
    CE - Microsoft

  • October 12, 2011 at 2:42 pm

    #1393707

    This typically happens when 1 or more fields exceeds the width restriction. However, I find it easier with Excel to SELECT * FROM table and then highlight the results, copy with headers, and then paste. Save you the hassle if this is a one time thing.

    Thanks,

    Jared

    Jared
    CE - Microsoft

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply