Skip to Content
0

excel 2016 files not recognized

Jun 20, 2017 at 03:27 PM

33

avatar image

I just upgraded to CR2016, however it does not give me the option to use excel 2016 files only xls files.

How do I fix??

10 |10000 characters needed characters left characters exceeded

found the answer!

I tried something different and it worked.

1) Download the https://www.microsoft.com/en-us/download/details.aspx?id=23734 from the Microsoft site , even though it states driver for 2007 , it works for office 2013 also

2) Once its downloaded then go back to Crystal report and do not go for ODBC , instead go for OLE connection then select "Microsoft Office 12.0 Access database Engine OLE DB Provider"

3) Select your .xlsx sheet from the datasource window

4) Select office database type as "Excel" ( This will only appear after you have installed the the driver vide step 1)

5) Click finish and now you have the .xlsx file connected just like any other database.

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

David Phillips Jun 20, 2017 at 08:46 PM
0

I tried something different and it worked.

1) Download the https://www.microsoft.com/en-us/download/details.aspx?id=23734 from the Microsoft site , even though it states driver for 2007 , it works for office 2013 also

2) Once its downloaded then go back to Crystal report and do not go for ODBC , instead go for OLE connection then select "Microsoft Office 12.0 Access database Engine OLE DB Provider"

3) Select your .xlsx sheet from the datasource window

4) Select office database type as "Excel" ( This will only appear after you have installed the the driver vide step 1)

5) Click finish and now you have the .xlsx file connected just like any other database.

Share
10 |10000 characters needed characters left characters exceeded
David Phillips Jun 21, 2017 at 11:27 AM
0

All is good thank you!

Share
10 |10000 characters needed characters left characters exceeded