Transfer data from access table into mysql table -

i'm trying transfer data access table mysql table using c#, since have big data can't transfer of data @ once using query

select * record

so instead used query transfer data

datatable ds = tempaccesscon.exexutesql("select top 100 *  record  time between #7/1/2013# , #7/31/2013#")

but problem query doesn't return of dates between #7/1/2013# , #7/31/2013#

please me transfer of data without repeating rows , missing row

thank

maybe date field datetime type

try

datatable ds = tempaccesscon.exexutesql("select top 100 *  record  time between          #7/1/2013 00:00:00# , #7/31/2013 23:59:59#")

Shashtri