I am trying to use a excel workbook as input to my crystal report. Here is the issue, I want to be able to use the add command and do a select instead of just selecting the sheets I want. IE I have 3 sheets and they are all summed at different levels. I want to be able to create a command (much like i would with a database) that says something like select group, value from MTM group by group.
But when I go to do the select * from mtm it says it doesn't know what that table is. Does anyone know the proper syntax for excel tables?