Question: how to import data from excel to crystal report?
Answer: Select New Report.
Select Data Base Expert.
Click on Create New Connection from the Data Tab. ... 
Select the OLEDB Provider as Microsoft Office 12.0 Access Database Engine OLE DB Provider.
Click Next.
Enter the Connection Information. ... 
Select Next and then select the fields to be viewed in the report.