将数据从访问表传输到mysql表

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

我正在尝试使用c#将访问表中的数据传输到mysql表中,但由于我有大数据,因此无法使用此查询一次性传输所有数据

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#

但问题此查询不会返回#7/1/2013#和#7/31/2013之间的所有日期#

please help me to transfer all of the data without repeating rows and missing any row

请帮我传输所有数据而不重复行并丢失任何行

thank you

1 个解决方案

#1

Maybe your date field is a dateTime type

也许你的日期字段是dateTime类型

Try this

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