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
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.
Just unzip and upload into your directory.
Ready to go XML file. The default directory is the Project directory, can be simply modified.
There are no side effects besides the necessaty to customize an Output directory.
Private Declare Function GetOpenFileName Lib "comdlg32.dll" Alias _
"GetOpenFileNameA" (pOpenfilename As OPENFILENAME) As Long
About this post
Viewed: 79 times
Posted: 9/3/2020 3:45:00 PM
Size: 11,559 bytes
No comments have been added for this post.
You must be logged in to make a comment.