2024-01-10から1日間の記事一覧
Option ExplicitSub Accessへのexport()Dim msn As WorksheetSet msn = ThisWorkbook.Worksheets("対象")Dim mycon As New ADODB.Connection 'データベース接続オブジェクトDim dbPath As StringdbPath = "Z:\Work\Database2.accdb"mycon.ConnectionString =…
Option ExplicitSub Accessへのexport()Dim msn As WorksheetSet msn = ThisWorkbook.Worksheets("対象")Dim mycon As New ADODB.Connection 'データベース接続オブジェクトDim dbPath As StringdbPath = "Z:\Work\Database2.accdb"mycon.ConnectionString =…