1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
|
'Open the connexion to the text file
cnx.ConnectionString = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=p:;" _
"Extensions=asc,csv,tab,txt;Persist Security Info=False;IMEX=1;"
cnx.Open
'Do and send the request
requete = "Select * from [Export.txt]"
rs.Open requete, cnx
rowIndex = rowStart
While Not (rs.EOF)
'Sorting criterias
If Not IsNull(rs.Fields(12)) Then
If CLng(rs.Fields(12)) < CLng(Sheet1.Cells(2, 7).value) Then
GoTo NotSelected
End If
If CLng(rs.Fields(12)) > CLng(Sheet1.Cells(3, 7).value) Then
GoTo NotSelected
End If
Else
If Sheet1.Cells(2, 7).value <> "" Then
GoTo NotSelected
End If
End If
Sheet1.Cells(rowIndex, 2).value = rs.Fields(0).value
Sheet1.Cells(rowIndex, 3).value = rs.Fields(1).value
Sheet1.Cells(rowIndex, 4).value = rs.Fields(2).value
Sheet1.Cells(rowIndex, 5).value = rs.Fields(3).value
Sheet1.Cells(rowIndex, 6).value = rs.Fields(21).value
Sheet1.Cells(rowIndex, 7).value = rs.Fields(17).value
Sheet1.Cells(rowIndex, 8).value = rs.Fields(18).value
Sheet1.Cells(rowIndex, 9).value = rs.Fields(19).value
Sheet1.Cells(rowIndex, 10).value = rs.Fields(20).value
Sheet1.Cells(rowIndex, 11).value = rs.Fields(6).value
Sheet1.Cells(rowIndex, 12).value = rs.Fields(23).value
Sheet1.Cells(rowIndex, 13).value = rs.Fields(8).value
Sheet1.Cells(rowIndex, 14).value = rs.Fields(9).value
Sheet1.Cells(rowIndex, 15).value = rs.Fields(11).value
Sheet1.Cells(rowIndex, 16).value = rs.Fields(7).value
Sheet1.Cells(rowIndex, 17).value = rs.Fields(12).value
Sheet1.Cells(rowIndex, 18).value = rs.Fields(13).value
Sheet1.Cells(rowIndex, 19).value = rs.Fields(14).value
Sheet1.Cells(rowIndex, 20).value = rs.Fields(15).value
Sheet1.Cells(rowIndex, 21).value = rs.Fields(16).value
Sheet1.Cells(rowIndex, 22).value = rs.Fields(10).value
Sheet1.Cells(rowIndex, 25).value = rs.Fields(22).value
rowIndex = rowIndex + 1
NotSelected:
rs.MoveNext
Wend
'Closing the connexion
rs.Close |
Partager