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

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


Îøèáêà â çàïðîñå

Ïîíåäåëüíèê, 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


 

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

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

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

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