Подключение к БД Access через Excel: "Ошибочный пароль". |
Sub DBConnetct() Dim MyDatabase As DAO.Database Dim rsCountry As DAO.Recordset Dim dbpath As String Dim wrb As Workbook Dim sht As Worksheet Dim c As Integer dbpath = "C:\TestDB.accdb" Set MyDatabase = DBEngine.OpenDatabase(dbpath, False, False, ";pwd=123") Set rsCountry = MyDatabase.OpenRecordset("SELECT * FROM tCountry") Set wrb = Workbooks.Add Set sht = wrb.Sheets(1) With sht .Name = "Country" .Range("A2").CopyFromRecordset rsCountry For c = 1 To rsCountry.Fields.Count sht.Cells(1, c).Value = rsCountry.Fields(c - 1).Name Next c End With End Sub
http://www.sql.ru/forum/1206294/podkluchenie-k-bd-access-cherez-excel-oshibochnyy-parol
Комментировать | « Пред. запись — К дневнику — След. запись » | Страницы: [1] [Новые] |