export access database to xml with vbs

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

export access database to xml with vbs

Logged in as: Guest

arrSession:exec spGetSession 2,2,2548

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> export access database to xml with vbs
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

export access database to xml with vbs - 4/2/2005 12:12:39 AM

big_ben

Posts: 1
Score: 0
Joined: 4/2/2005
From: France
Status: offline

Hello, I'm french and newbie in programmation. I need to write a script to export database to an xml file. I have wrote this:

Dim db, fx
Dim sourcepath
Dim destpath
sourcepath = "C:\Documents and Settings\Administrateur\Bureau\db1.mdb"
destpath = "C:\Documents and Settings\Administrateur\Bureau\essai.xml"
Set db = CreateObject("Access.Application")
Set fx = CreateObject("xml.Document")
db.opencurrentdatabase sourcepath
db.Visible = False
fx.ExportXML "Graphics","db","destpath"
db.closecurrentdatabase

but it doesn't work.....If somebody could help me it would be great
Thanks