KC的记事本

摘要： 在用ADO读取Excel文件数据，常容易发生丢失数据的现象。例如，用ADO打开一个Excel文件的代码如下：Dim objConn As ADODB.Connection Dim objRS As ADODB.Recordset Dim objRSTable As ADODB.Recordset Set objConn = New ADODB.Connection Set objRS = New ADODB.Recordset objRS.CursorLocation = adUseClient With objConn .Provider = "Microsoft.Jet.... 阅读全文