Âñòàâèòü äàííûå â 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
| Êîììåíòèðîâàòü | « Ïðåä. çàïèñü — Ê äíåâíèêó — Ñëåä. çàïèñü » | Ñòðàíèöû: [1] [Íîâûå] |