Importing Excel-files in Crystal Reports

[iemand]

How do I import an Excel-file into Crystal Reports?

 

[CarolineS]

In Excel, go to Tools>Add-ins and check the Crystal Reports Wizard. If there is no Crystal Reports Wizard available, hit the Browse button and find the file called crptxls.xla in C:\Program Files\Seagate Software\Report Designer Component.

Double-clicking it will allow you to now select Crystal Reports Wizard as one of your Add-Ins. A little Crystal logo should then appear in your Excel taskbar. Open an Excel file, arrange it, and then hit the Crystal button to export.

 

[Halfcan]

I would set the ODBC up as a System DSN, We access our excel ODBC over a network, and although I'm not positive,
I think it has to be set up as a System DSN to be available to more than 1 machine. Can Anyone comment?

Also, with system DSN's I've found that if you don't have "Show System Tables" checked, when you add new fields to your excel file, they will not show up.

"Show System Tables" can be found in File > Options > Database Tab >

Andy