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
| Private Sub CmdExport_Click()
Dim rs As ADODB.Recordset
Dim f
Dim s As String
Dim sep As String
Dim t() As String
Dim i As Integer
sep = ""
While Not EOF(f)
Line Input #f, s
t() = Split(s, sep)
' pour virer les guillements superflus,
' inutile avec mon export.
For i = LBound(t()) To UBound(t())
t(i) = Replace(t(i), Chr$(34), Chr$(0))
Next i
rs.AddNew
rs.Fields("Centre") = t(0)
rs.Fields("datedujour") = CDate(t(1))
rs.Fields("codeenfant") = CLng(t(2))
rs.Fields("Nom") = t(3)
rs.Fields("Prénom") = t(4)
rs.Fields("Datenaissance") = CDate(t(5))
rs.Fields("QF") = t(6)
rs.Fields("BV2007") = CBool(t(7))
rs.Fields("Nbdejours") = CLng(t(8))
rs.Fields("Adresse") = t(9)
rs.Fields("Ville") = t(10)
rs.Fields("CodePostal") = CLng(t(11))
rs.Update
Wend
End sub |
Partager