how to use between query

This Is simple If U have two date and want to select the value or data between two date, the use this code.

SELECT Date From TableName Where (date BETWEEN @date1 AND @date2)

Go through these link for oledb connection string.
http://www.carlprothman.net/Default.aspx?tabid=87[^]

http://www.connectionstrings.com/access[^]

go through these links to use between operator

http://www.java2s.com/Code/Oracle/Select-Query/UsingtheBETWEENOperatorforinteger.htm[^]

http://www.w3schools.com/Sql/sql_between.asp[^]

Try by your self and let me know if you are facing any problem