check the follwing link

http://vb.net-informations.com/framework/what_is_net_framework.htm

thanks.

read the data to a gridview and write it to the excel table.

http://vb.net-informations.com/excel-2007/vb.net_export_from_database_to_excel.htm

it may help u.

go through the following link about connect excel file through vb.net.

http://vb.net-informations.com/excel-2007/vb.net_excel_2007_open_file.htm

thanks.

you can use if statements.

If [your condition here]
Your code here
ElseIf [your condition here]
Your code here
ElseIf [your condition here]
Your code here
Else
Your code Here

didnt find any mistakes in ur code

u just try this code

Dim CrFormatTypeOptions As New ExcelFormatOptions
CrDiskFileDestinationOptions.DiskFileName = _
...

It may be with your connection problem.

check this.

http://vb.net-informations.com/crystal-report/vb.net_crystal_reports_tutorials.htm

carlos

Option Strict is prevents program from automatic variable conversions, that is implicit data type conversions

http://vb.net-informations.com/language/vb.net_option_strict.htm
...