Âòîðíèê, 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
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-