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.
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.