ÈÌÏÎÐÒ XML Â ÒÀÁËÈÖÛ ACCESS
|
|
×åòâåðã, 27 Àâãóñòà 2015 ã. 15:56
+ â öèòàòíèê
Sub haba()
On Error GoTo ErrExit
Dim rs As Object 'DAO.Recordset
Dim xmlDoc As Object 'MSXML2.DOMDocument
Dim xmlNode As Object 'MSXML2.IXMLDOMNode
Dim xmlNode1 As Object 'MSXML2.IXMLDOMNode
Dim xmlAttribut As Object 'MSXML2.IXMLDOMAttribute
Dim xmlNodeList As Object 'MSXML2.IXMLDOMNodeList
Dim xml_path As String
Dim FileName As String
Dim NameOrg, INN, KPP
'
Set rs = CurrentDb.OpenRecordset("select * from Tab where 1=0")
'
Set xmlDoc = CreateObject("MSXML2.DOMDocument")
xmlDoc.async = False
FileName = CurrentProject.path & "\Oborot.xml"
If Not xmlDoc.Load(FileName) Then Exit Sub
'
Ïîäñêàæèòå ïîæàëóéñòà èìåÿ òàêîé êîä êàê ðåàëèçîâàòü çàãðóçêó âñåõ ôàéëîâ èç ïàïêè èìåÿ ðàñøèðåíèå xml, à íå ãðóçèòü èõ ïî îäíîìó. íàïðèìåð ôàéëû íà ñ:\5555\ *.xml , êàê ýòî êîäîì ðåàëèçîâàòü ñïàñèáî.
http://www.sql.ru/forum/1172735/import-xml-v-tablicy-access
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-