Export data from SQL Server database to Excel

Following is the error message I get whenever I try to export data from my SQL Server 2008 database to Excel 2007 file (xlsx):

Pre-execute (Error) 

        Messages 

        *   Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E21.
             (SQL Server Import and Export Wizard)

        *   Error 0xc0202025: Data Flow Task 1: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
             (SQL Server Import and Export Wizard)

        *   Error 0xc004701a: Data Flow Task 1: component "Destination - tblAddress" (49) failed the pre-execute phase and returned error code 0xC0202025.
             (SQL Server Import and Export Wizard)

This happens for any table I try to export. I didn't find any issue with the metadata.

What could be the possible reason? or how to resolve it?