Private Sub cmdImporter_Click() Dim AppAccess As New Access.Application Dim SpecificationName As String, TableName As String, FileName As String, Libellé As String If Trim(txtPc.Text) = vbNullString Then MsgBox "Veuillez saisir un libellé de pc", vbInformation, "Information" txtPc.SetFocus End If If Trim(txtChemin.Text) = vbNullString Then MsgBox "Veuillez saisir un fichier .csv", vbInformation, "Information" btnChemin.SetFocus Else SpecificationName = "SpecImportAida" TableName = "TableImport" FileName = txtChemin.Text Libellé = txtPc.Text AppAccess.OpenCurrentDatabase "Z:\Projet AIDA\Données\access.mdb" Call AppAccess.DoCmd.RunSQL("DELETE * FROM " & TableName & " WHERE Libellé = '" & Libellé & "'") Call AppAccess.DoCmd.TransferText(, SpecificationName, TableName, FileName) Call AppAccess.DoCmd.RunSQL("UPDATE " & TableName & " SET Libellé = '" & Libellé & "' WHERE Libellé IS NULL") AppAccess.CloseCurrentDatabase AppAccess.Quit acQuitSaveNone Set AppAccess = Nothing End If End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question