I retrieved data from access in vb10 between two dates and here is the code for dat:

Imports System.Data.OleDb
Public Class Form4
    Dim con As OleDbConnection
    Dim cmd As OleDbCommand
    Dim dr As OleDbDataReader
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
            con = New OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;" & _
"Data Source=C:/Users/Space Era/Documents/perf.mdb")
            Dim dataset1 As New DataSet()

            Dim sqlstring As String = "SELECT data.[S No], data.Date, data.[Server Name], data.Directory, data.Media, data.[Media id], data.Status, data.[Start Time], data.[End Time], data.[Action taken], data.[Backup taken by], data.[Tape Name] FROM data where Date>= '" & DateTimePicker2.Text & "' and Date <'" & DateTimePicker1.Text & "' "
            cmd = New OleDbCommand(sqlstring, con)
            Dim oledbdataadapter1 As System.Data.OleDb.OleDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter(cmd)
            oledbdataadapter1.Fill(dataset1, "data")

            DataGridView1.DataSource = dataset1.Tables("data")

        Catch ex As Exception
        End Try
    End Sub

now i want to display the result in excel sheet...if nybdy out there cn suggest smthng..i wud be greatful..

it didn't help..i need to finish this quick..plss smbdy help...

Do you have some code, that you want help with or need the hole thing ready?

One which I use in my project is by using crystal report.
Crystal report provide you a facility to export your report in excel format.