Re: Tworzenie pliku xml dla danych z tabeli za pomocą pliku vbs

Article View: pl.comp.bazy-danych.msaccess

Article #137628

Back to pl.comp.bazy-danych.msaccess Previous Next

#137628

From: Phantom
Date: Mon, 30 Jul 2018 12:04

23 lines
2145 bytes

Działa!
Nawet podmienia plik xml na nowy (wielokrotne wywoływanie funkcji).
Zastanawiam się czy dla pewności nie usuwać starego pliku xml przed tworzeniem nowego.

Moja funkcja wygląda teraz tak:

Const acExportTable = 0 
Const acQuitSaveNone = 2 
Const acUTF8 = 0 
Dim oApp 

   Set oApp = CreateObject("Access.Application") 
     oApp.OpenCurrentDatabase "G:\Dec_Publ.mdb", False 
     oApp.ExportXML acExportTable, "Dec_Publ_Tab", "G:\Dec_Publ_Tab_Proba.xml", , , , acUTF8 
     oApp.CloseCurrentDatabase 
     oApp.Quit acQuitSaveNone 
   Set oApp = Nothing 

Brakuje linii z usuwaniem pliku.
Jeśli można prosić!

Pozdrawiam
Tomek

Technical Details

Message-ID: <ab6cf269-fae2-4f89-bd3e-2bb1c779a5aa@googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder-in1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!e8-v6no1538663qtp.0!news-out.google.com!g23-v6ni62qtp.0!nntp.google.com!e8-v6no1538662qtp.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail

References: <ba1c4dee-528e-43b7-924e-7932bef57f48@googlegroups.com> <pjmhc3$1b7$1@node2.news.atman.pl>

Show Full Headers

Complete Article Headers

X-Received: by 2002:ae9:e116:: with SMTP id g22-v6mr10475667qkm.31.1532952253353;        Mon, 30 Jul 2018 05:04:13 -0700 (PDT)
X-Received: by 2002:a0c:b98d:: with SMTP id v13-v6mr153859qvf.0.1532952253177; Mon, 30 Jul 2018 05:04:13 -0700 (PDT)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder-in1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!e8-v6no1538663qtp.0!news-out.google.com!g23-v6ni62qtp.0!nntp.google.com!e8-v6no1538662qtp.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: pl.comp.bazy-danych.msaccess
Date: Mon, 30 Jul 2018 05:04:12 -0700 (PDT)
In-Reply-To: <pjmhc3$1b7$1@node2.news.atman.pl>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=185.157.12.165; posting-account=ktj0zQoAAADJqs80HwZLH7C5CXWNQqRK
NNTP-Posting-Host: 185.157.12.165
References: <ba1c4dee-528e-43b7-924e-7932bef57f48@googlegroups.com> <pjmhc3$1b7$1@node2.news.atman.pl>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <ab6cf269-fae2-4f89-bd3e-2bb1c779a5aa@googlegroups.com>
Subject: Re: Tworzenie pliku xml dla danych z tabeli za
 pomocą pliku vbs
From: Phantom <biuro.tekaoprogramowanie@gmail.com>
Injection-Date: Mon, 30 Jul 2018 12:04:13 +0000
Lines: 24
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message