Access Excel |
Sub () Dim connDB As Object Set connDB = CreateObject("ADODB.Connection") connDB.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; data source=" & "G:\3\A.accdb" connDB.Open connDB.Execute = "CREATE TABLE RRR" & "(ID COUNTER, DATETIME, TEXT, TEXT, TEXT, TINYINT, TEXT);" connDB.Close Set connDB = Nothing End Sub
Sub Insert() Dim connDB As Object Dim sss As String Dim ddd As String sss= "" ddd= "" Set connDB = CreateObject("ADODB.Connection") connDB.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; data source=" & "G:\3\A.accdb" connDB.Open connDB.Execute = "INSERT INTO RRR VALUES( Cells(1,1).Value , sss, ddd)" connDB.Close Set connDB = Nothing End Sub
http://www.sql.ru/forum/1284080/vstavit-dannye-v-access-iz-excel-posledovatelno-i-iz-yacheyki