Ïîíåäåëüíèê, 11 ßíâàðÿ 2016 ã. 14:38
+ â öèòàòíèê
Äîáðûé äåíü, ïîäñêàæèòå ãäå îøèáêà êðîåòñÿ?
Set db = CurrentDb()
Set rs = db.OpenRecordset(" select dbo_UPR_1214.kod_upr, dbo_StrEd_18.nStrEd FROM dbo_UPR_1214, dbo_StrEd_18,
[Excel 12.0 xml;HDR=Yes;IMEX=1;DATABASE=" & Me.Form.l1.Value & "].[Ëèñò1$] AS Ex Where dbo_UPR_1214.kod_upr = Ex.[Êîä óïðàâëåíèÿ] ")
Âûõîäèò ñîîáùåíèå ÷òî ñëèøêîì ìàëî ïàðàìåòðîâ. Òðåáóåòñÿ 1.
Ïðîâåðèë ïîëÿ â òàáëèöå, òàêîå òî÷íî åñòü.
Èìÿ ñòîëáöà copy-paste èç ôàéëà
http://www.sql.ru/forum/1194585/oshibka-v-zaprose
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-