how to link excel sheet with Crystal Report

How can i be able to link excel file with crystal report
i tried OLE and was succeeded but with problem that it displays the cells lines that are not needed.

second thing i was trying to do it through dsn (tried all the 3 dsn types)
but when i connect crystal report with it using ODBC it shows me
"No Items found".

any suggestion ?when i link excel file with Crystal Report8.5
as an OLE i see some extra blank cells with it on the right side and when i take a print of it, these cells are also printed

i used crystal report control to connect vb with report
the code is here
cr1 is the Crystal Report Control's Name
Code:

cr1.DiscardSavedData = True
cr1.ReportFileName = "C:\myexcelreport.rpt"
cr1.Destination = crptToWindow
cr1.ReportSource = crptReport
cr1.WindowShowRefreshBtn = True
cr1.WindowShowExportBtn = True
cr1.WindowShowPrintBtn = True
cr1.Action = True



Is there any way to dislpaly only the desired area of the excel file in report ?|||Hey guys
Finally got the solution.............|||hi

do u know how to import the fields from crystal report to an excel spreadsheet

or

to import values resulting from a query to a spreadsheet?

Thanks.