插入数据库太慢怎么办
我希望能将一个excel文件中的数据一行行插入数据库中,却发现速度很慢,不知道为什么
程序代码如下
Set rs = New ADODB.Recordset
rs.Open "select * from custom", conn, adOpenStatic, adLockOptimistic
rowCount = xlsheet.UsedRange.Rows.Count
For rowNum = 2 To rowCount
customName = xlsheet.Cells(rowNum, 1).Value
shortCustomName = xlsheet.Cells(rowNum, 2).Value
department = xlsheet.Cells(rowNum, 3).Value
rs.AddNew
rs!企业全名 = customName
rs!企业简称 = shortCustomName
rs!部门 = department
Next rowNum
rs.update
请问是什么原因呢,是因为记录集的打开方式不合适吗?