1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| Dim WrkSpaceODBC As Workspace
Dim ConnectODBC As Connection
Dim rcd As Recordset
Set db = CurrentDb
Set WrkSpaceODBC = DBEngine.CreateWorkspace("ODBC", "Admin", "", dbUseODBC)
Set ConnectODBC = WrkSpaceODBC.OpenConnection("", dbDriverNoPrompt, False, "ODBC;DRIVER={SQL Server};Server=XXX;Database=ZZZZZZ;UID=ss;Pwd=zzzzz")
Set rcd = ConnectODBC.OpenRecordset("EXEC Buro_Articles_1 @Fichier_Origine = 'CatSp.txt'")
Set rcd = ConnectODBC.OpenRecordset("SET LANGUAGE US_ENGLISH " & _
"EXEC Buro_Articles_2 @NiveauRem = 1")
rcd.Close
ConnectODBC.Close
WrkSpaceODBC.Close |
Partager