Äîáðûé Äåíü, ìîæåò ÿ ïëîõî èñêàë íî ðåøåíèÿ òàê è íå íàøåë. Ó ìåíÿ â áàçå ACCESS ôîðìèðóåòñÿ èç òàáëèöû íåêîòîðàÿ èíôîðìàöèÿ êîòîðàÿ â xml ôîðìàòå ìåòîäîì POST ïåðåäàåòñÿ íà ñåðâåð. Ïåðåä îòïðàâêîé ÿ ñîõðàíÿþ äàííûå â txt ôîðìàòå äëÿ ïðîâåðêè åñëè ïîòðåáóåòñÿ (êàê áû ëîã ôàéë), ïîñëå îòïðàâêè äàííûõ, ïîëó÷àþ îòâåò îò ñåðâåðà è îïÿòü çàïèñûâàþ åãî â txt ôàéë ñîõðàíÿþ êàê log. À âîò äàëüøå èäåò ìîÿ ïîëíàÿ áåçãðàìîòíîñòü íå ñìåéòåñü, ÿ êîïèðîâàë òõò ôàéë ñ äàííûìè îò ñåðâåðà, ñîõðàíÿë êàê xml è èìïîðòèðîâàë â Access. Âñå áû õîðîøî, íî äåëî äîøëî äî ðóññêîãî òåêñòà â ôàéëå, è íà ýòîì âñå çàñòîïîðèëîñü. Òåêñò ñîõðàíÿåòñÿ â ANSI à ìíå íóæíî ÷òîáû â utf-8. Âîò çäåñü è âîçíèêàåò âîïðîñ 1 êàê ïîìåíÿòü êîäèðîâêó â txt ôàéëå ñðåäñòâàìè VBA. È âòîðîé âîïðîñ ÿ ïîäîçðåâàþ, ÷òî ïóòü êîòîðûì ÿ èìïîðòèðóþ xml ôàéë õîòü è ðàáî÷èé íî, êàê áû âûðàçèòüñÿ íå êðàñèâûé ÷òî-ëè, íå ïðàâèëüíûé îí, âåäü ìîæíî ïðîñòî âçÿòü äàííûå êîòîðûå ÿ ïîëó÷èë îò ñåðâåðà è áåç ëèøíèõ îïåðàöèé èìïîðòèðîâàòü â áàçó äàííûõ, íî âîò êàê ýòî ñäåëàòü íå çíàþ.
Çàðàíåå ñïàñèáî.
1 Private Sub check_etr_Click()
2 On Error GoTo Err_check_etr_Click
3 Set objXml = CreateObject("Msxml2.XMLHTTP")
4 Set objXmlDoc = CreateObject("MSXML2.DOMDocument")
5 Dim rs As Recordset
6 Dim doc As String, ccode As String, x As String, y As String, my_rc As String
7 Dim rc_int As Integer, rc_full As Double, z As Integer
8 Set rs = CurrentDb.OpenRecordset("check_entered_cards")
9 If rs.RecordCount > 0 Then
10 rs.MoveFirst
11 Do While Not rs.EOF
12 mycart = "
" & rs("card_code") & "" & mycart
13 rs.MoveNext
14 Loop
15 End If
16 strXML = "" & _
17 "
" & _
18 mycart & _
19 "" & _
20 Open "D:\c_info_list_exp.txt" For Output As #1
21 Print #1, (strXML)
22 Close #1
23 objXml.Open "POST", "
http://000.000.000.000:81/UCS/SOAP/SOAP.php?xml_data=" & strXML, False
24 objXml.send (strXML)
25 Open "D:\c_info_list.txt" For Output As #1
26 Print #1, strXML
27 Close #1
28 FileCopy "D:\c_info_list.txt", "D:\c_info_list" & ".xml"
29 ImportXML "D:\c_info_list.xml"
30 Exit_check_etr_Click:
31 Exit Sub
32 Err_check_etr_Click:
33 MsgBox Err.description
34 Resume Exit_check_etr_Click
35 End Sub
http://www.sql.ru/forum/1155649/izmenenie-kodirovki-txt-fayla