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
| SET mybase = New ADODB.Connection
mybase.ConnectionString = "Provider=msdaora;Data Source=xxxx;User Id=xxx;Password=xxxxx;"
mybase.Open
SET mycommande = New ADODB.Command
mycommande.ActiveConnection = mybase
mycommande.CommandText = "CREATE TABLE TOTO (SIRET varchar(14) primary key)"
mycommande.Execute
"Import du fichier TXT dans EXCEL"
Workbooks.OpenText Filename:=fichier, Origin _
:=xlMSDOS, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=True, _
Comma:=False, Space:=False, Other:=False, FieldInfo:=Array(1, 2), _
TrailingMinusNumbers:=True
"On récupère l'adresse de la dernière ligne du tableau"
Range("A1").Select
der_row = ActiveCell.CurrentRegion.Row + ActiveCell.CurrentRegion.Rows.Count - 1
For i = 1 To der_row
strImport = Mid(Worksheets(Application.ActiveSheet.Name).Cells(i, 1).Value, 1, 14)
mycommande.CommandText = "BEGIN INSERT INTO TOTO VALUES('" & strImport & "'); COMMIT; END;"
mycommande.Execute
Next i |
Partager