请教一个关于access的效率问题

最近刚学vb2008，用oledb来直接操作access，操作都算比较正常，但是有一个问题就是插入的效率非常非常低，比如说我插入4000行的数据，竟然要等个好几分钟，这种效率实在是不能让人接受

看了网上很多文章都说access的效率不高，但是我觉得即使不高也不至于那么慢吧，所有应该还是我的写法有问题吧。把代码贴上来，不知道大家有什么看法。

似乎dataset 的效率要高一点，改天试试

代码如下：
VB.NET code:


For Each glData As sdata In DataList

QueryString = "INSERT INTO " & TableName & " VALUES ( #" & glData.sDate & "# ," & glData.sOpen & "," _
& glData.sHigh & "," & glData.sLow & "," _
& glData.sClose & "," & glData.sAmount & "," _
& glData.sVolumne & ")"

Using Command As New OleDbCommand(QueryString, OleDbConnection)

Try
OleDbConnection.Open()

If OleDbConnection.State = ConnectionState.Open Then

Command.ExecuteNonQuery()

counter = counter + 1