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

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

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

 

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

 -Ñòàòèñòèêà

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


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

Âòîðíèê, 26 ßíâàðÿ 2016 ã. 07:02 + â öèòàòíèê
Äîáðûé äåíü, ñíîâà íóáñêèé âîïðîñ) ïîðà óæå ðåãèñòðèðîâàòüñÿ íàâåðíîå)
sqlConn = "Insert into TempEx (kod_25,kod_upr,kod_18,name) select [¹ äîãîâîðà ÑÀÏ (25 ñïðàâî÷íèê)],[Êîä óïðàâëåíèÿ],[Êîä Êîíòðàãåíòà (18 ñïðàâî÷íèê)],[Íàèìåíîâàíèå óñëóãè] from  [Ëèñò1$]"
strConn = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source = " & Me.Form.l1.Value & "; Extended Properties=""Excel 12.0 xml;HDR=Yes"""
exConn.ConnectionString = strConn
exConn.Open
exConn.Execute (sqlConn)


Ïîäêëþ÷åíèå ñîçäàåòñÿ áåç îøèáîê, ïðè âûïîëíåíèè çàïðîñà âûäàåò îøèáêó
Èç äåáàãà
?sqlConn
Insert into TempEx (kod_25,kod_upr,kod_18,name) select [¹ äîãîâîðà ÑÀÏ (25 ñïðàâî÷íèê)],[Êîä óïðàâëåíèÿ],[Êîä Êîíòðàãåíòà (18 ñïðàâî÷íèê)],[Íàèìåíîâàíèå óñëóãè] from [Ëèñò1$]

http://www.sql.ru/forum/1197210/oshibka-zaprosa


 

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

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

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

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