|
大家帮忙看下,哪里有问题,导入数据总是导不全,只能导入一半不到
- Sub 导入()
- Dim FName As Variant
- Dim myPath$
- Dim aFile
- Dim i
- Dim cnn
- Dim rs
- Dim sql
- FName = Application.GetOpenFilename(FileFilter:="CSV ???(*.csv),*.csv", FilterIndex:=1, Title:="??????????")
- If FName <> False Then
- aFile = Split(FName, "")
- myPath = aFile(0)
- For i = 1 To UBound(aFile) - 1 '???????·??
- myPath = myPath & "" & aFile(i)
- Next
- Else
- End
- End If
- Set cnn = CreateObject("ADODB.Connection")
- cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='text;hdr=no;FMT=DELIMITED';Data Source=" & myPath
- sql = "Select f9,f7,f4,f5,f22 From " & Replace(FName, myPath, "")
- Sheets("sheet2").[A2:O1000000].ClearContents
- Set rs = cnn.Execute(sql)
- rs.Move 1
- Sheets("sheet2").[A2].CopyFromRecordset rs
- MsgBox ”更新完成"
- End Sub
复制代码
|
|