-

   rss_sql_ru_access_programming

 - e-mail

 

 -

 LiveInternet.ru:
: 16.03.2006
:
:
: 4

:


Access Excel

, 31 2018 . 23:17 +




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



, :

1. ? ( , INSERT Cells...
2. sss ddd?
3. ID , INSERT, Cells(1,1).Value , sss 5 ddd 7)??

?
INSERT INTO RRR VALUES( , ,Cells(1,1).Value , ,sss, ,ddd)" ...? ))

...)

http://www.sql.ru/forum/1284080/vstavit-dannye-v-access-iz-excel-posledovatelno-i-iz-yacheyki


: [1] []
 

:
: 

: ( )

:

  URL