I have Office 2007. I'm trying to take an Excel spreadsheet that has budget numbers for one our our satellite companies where we don't have access to their database yet and import it into Crystal reports. I'll go to Create new connection and choose Access/Excel. I browse to my Excel spreadsheet, change the selection to Excel and click Finish. I get a connection that shows the path of my spreadsheet and below it Add Command. There should be a choice of which worksheet to use but that's not there. If I try to add the spreadsheet on Selected Tables, nothing happens. When I Finish, there is nothing in my Crystal Report.
What am I doing wrong?