Can we import extact Excel file in Crystal report in BO

[Former Member]

an we import extact Excel file in Crystal report in BO

if yeh

den HOW

[former_member260594]

Amit,

You can insert Excel Spreadsheets as OLE Objects but you would be limited as CR would only display it on 1 page. You would be better off inserting a subreport that is connected to that excel file and reporting off it.

[Former Member]

Hi Amit,

There is no functionality to import the data from MS Excel to Crystal reports. However we can connect to the Excel sheet as a data source and create Crystal reports against Excel.

Some popular choices in the Create New Connection folder are described here:

Access/Excel (DAO)

This option lets you connect to a supported database type (Access, Excel, Lotus, and so on).

I hope this helps you.

Regards,

Prashant

[former_member230846]

Hi Amit,

Please respond with a detailed description of what you're trying to do.

Regards,

Wallie