Yes you can use Crystal Reports to retrieve data from Excel. If you have
Crystal and Excel installed on the same machine, open your Excel document.
Click the Tools button on the Menu Bar....see if Crystal Report Wizard is
there....if it is, simply highlight the data you want in the report and click
Crystal Report Wizard.
If you wish to do this in a traditional manner, open a new report in
Crystal. Whether you choose to use the Report Wizard or a Blank Report, once
you click OK (on the Crystal Reports Gallery), you will have to next pick an
Available Data Source.
1. Choose " Create New Connection " by clicking the + to expand it
2. Double click on " Access/Excel (DAO)
3. Click the arrow on Database Type and pick the version of Excel you have
4. Click the ...button (Database Name), find and select your Excel
spreadsheet
5. Click FINISH
6. You will see the connection in the Available Data Sources window
7. Find the SHEET you want (may be named 'Sheet1$' if you didn't name it in
Excel) and double click it....it will appear in the Selected Tables window.
8. Repeat #7 for every sheet you need (you will have to link them when you
click the Finish button)
There you go...should work like a charm,
TomB.
