Bonjour
j´ai une erreur sur mon export des donnes vers access le code
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11 Dim db As DAO.Database Dim strsql As String Set db = DBEngine.OpenDatabase("mabase") strsql = "insert into tbl_info(Projectnom ) values('" & Worksheets("table1").Cells(1, 3).value & "' )" strsql = strsql + "insert into tbl_info(version) values (" & Worksheets("table1").Cells(2, 3).value & ")" strsql = strsql + "insert into tbl_info(chefnom) values ('" & Worksheets(1).Cells(4, 3).value & "')" strsql = strsql + "insert into tbl_info(responsable) values ('" & Worksheets(1).Cells(6, 3).value & "')" strsql = strsql + " insert into tbl_info (team ) values ( '" & Worksheets(1).Cells(9, 3).value & "');" db.Execute strsql
Partager