Crystal Report Adding Excel 12.0 database type to Visual Studio 2008 RRS feed

  • Question

  • I am using VS2008 and Crystal Report to read Excel file.  After selecting "Make New Connection", I can see the selection in "DataBase Type" consists of Excel 3.0 ... to Excel 8.0.   Selecting Excel 8.0 will not be able to open xlss (2007 Worksheet). 

    How to add Excel 12.0 into Crystal Report of VS2008 in order to open/read xlss and xls (97-2003 Worksheet) ?

    Thanks for any kind expert on this .

    Thursday, July 14, 2011 6:59 AM


  • Hi JChoong,

    CR for Visual Studio 2010 now supports XLXS files through ODBC or OLE DB connection. For CR Basic for VS 2008 try the same, it may work. If not no option but to upgrade.


    Don Williams
    Thursday, July 14, 2011 1:06 PM