Access_TO_XML

Using this Program one can browse for Access Database through Network or local computer, pick a table you want to make an XML file from, and finally push a button to create a file in XML format. One can also display the newly created XML file and print it into Textbox with further "copy-and-paste".
For database browsing I used an API call: GetOpenFileName Lib "comdlg32.dll" instead of bulky CommonDialog Control.
For getting a tablenames of the database I used OpenSchema(adSchemaTables)for create Connection and then simply added tablenames into Combobox.
Then I used File access VB feature to write an XML file from access table, reading column names and columns, converting it into XML format and writing on disk.
The last feature this program has to print out a newly created XML file into Textbox for analysis and, if necessary, "copy-and-paste".

Original Author: Natalia Babkina

Inputs

All the inputs are: Access Database Path and name like: C:My DatabasesMyData.mdb
I use "Browse for files" using API call:
GetOpenFileName Lib "comdlg32.dll", it works faster.

Assumptions

Just unzip and upload into your directory.

Returns

Ready to go XML file. The default directory is the Project directory, can be simply modified.

Side Effects

There are no side effects besides the necessaty to customize an Output directory.

API Declarations

Private Declare Function GetOpenFileName Lib "comdlg32.dll" Alias _
"GetOpenFileNameA" (pOpenfilename As OPENFILENAME) As Long

About this post

Posted: 2002-06-01
By: ArchiveBot
Viewed: 98 times

Comments

No comments have been added for this post.

You must be logged in to make a comment.