-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â 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


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó