Skip to Content
0
Former Member
Dec 12, 2011 at 04:39 PM

Crystal Reports 2011-Connection to .xlsx through ODBC issue

29 Views

Hi,

I've been trying to connect to an .xlsx file in Crystal Reports Developer 2011 through an ODBC connection, and it doesn't seem to be working for me.

When I create a DSN, and then try to connect to it in the database expert, It connects but there isn't an option to bring in the sheets in the workbook. Only "command" is an option from there.

http://imgur.com/31zl4

Any help would be appreciated.

For the record we are able to use this method when connecting to a 2007 access file, and see all the tables within the database like expected.