Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: xlsx no sheet problem Post Reply Post New Topic
Author Message
Macavity
Groupie
Groupie


Joined: 24 Sep 2012
Online Status: Offline
Posts: 93
Quote Macavity Replybullet Topic: xlsx no sheet problem
    Posted: 07 Jan 2016 at 6:10am
Hi,

In the excel I selected a named range

To connect to a 2010 excel, I created a ODBC datasource (test1) with driver :
Microsoft Excel Drive (*.xls,*.xlsx,*.xlsm,*.xlsb) and connected it to the excel

In Crystal connect to ODBC test1
In Crystal in connection options I checked system files.

With all of this I should be able to read the xlsx file in Crystal.

However, the excel appears on the left, but without a sheet, only add command so I can't move it to the right. I don't want to use add command.
How can I make the sheet visible ?

thanks
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 18 Jan 2016 at 4:48am
What version of Crystal are you using?

-Dell
IP IP Logged
Macavity
Groupie
Groupie


Joined: 24 Sep 2012
Online Status: Offline
Posts: 93
Quote Macavity Replybullet Posted: 19 Jan 2016 at 3:39am
9

IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 19 Jan 2016 at 4:06am
That version of Crystal went out of support over 10 years ago.  It is not able to connect to .xlsx files, even through ODBC.

-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.