Transfer data from access table into mysql table

Transfer data from access table into mysql table

I'm trying to transfer data from my access table into mysql table using
c#, but since I have big data I can't transfer all of that data at once
using this query
select * from record
so instead I used this query to transfer the data
DataTable ds = tempaccesscon.exexutesql("select top 100 * from record
where time between #7/1/2013# and #7/31/2013#")
but the problem this query doesn't return all of the dates between
#7/1/2013# and #7/31/2013#
please help me to transfer all of the data without repeating rows and
missing any row
thank you