Joined: 03 Mar 2010
Online Status: Offline
Posts: 33
Topic: CR 2011 Connection to 2010 Excel Posted: 23 Aug 2012 at 10:19am
In the Crystal 2008 version I was able to connect to an Excel spreadsheet through DAO and I now see I can't do that in the 2011. Is there an updated driver I need to have to make this work? Has anyone else come across or used this connection before? I have existing reports that are set up this way and now need to connect to the new .xlsx files.
Joined: 03 Mar 2010
Online Status: Offline
Posts: 33
Posted: 23 Aug 2012 at 10:50am
I have been doing it that way for quite some time with earlier .xls file types through DAO with no problems. So how do I set up a ODBC connection? I tried it and it is requiring a user name and password. There's no way to bypass something like that? Does that have to be set up through an administrator?
Joined: 03 Mar 2010
Online Status: Offline
Posts: 33
Posted: 23 Aug 2012 at 10:59am
I just tried it now and connect to an Access database just fine like I have before.
The latest version I get for Excel to connect this way is Excel 8.0 from my list of choices which lets me connect to earlier excel versions but not the new .xlsx version.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 23 Aug 2012 at 11:02am
I remember seeing a posting on some forum about not being able to use Excel 2007-2010 as a data source. But I do not know if they ever found a workaround. Wish I knew more about it.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 23 Aug 2012 at 11:24am
I just created an ODBC connection to an Excel 2010 spreadsheet (I had to choose the correct driver from the list, Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb). It appears to work okay. Of course if you cannot use an ODBC driver, then I do not have any other suggestions.
Joined: 03 Mar 2010
Online Status: Offline
Posts: 33
Posted: 24 Aug 2012 at 2:54am
It's xlsx because the number of rows in it exceeds what xls would accept and users still use it and refer to it. The reason why I am trying to connect to it like I easily can to .xls is to create Crystal reports from it and automate them through a Business Objects environment.
Joined: 03 Mar 2010
Online Status: Offline
Posts: 33
Posted: 24 Aug 2012 at 3:26am
I can create a report from the csv so I may need to come up with a procedure to copy this as a csv each month that this file is updated. And yet the end users will still use the .xlsx file.
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
IP Logged
