Miscellaneous Question

Does anyone have the tool to convert MSI files to Access (mdb) file format?

07/16/2016 1387 views
i know that this is a long shot, but many years ago I came across a tool that could read MSI database file and convert them to access files, purely for the visualisation of the relationships between the tables. Does anyone still have this in their bag of tools? (VBScab, Captain or perhaps EdT?)

Answer Summary:
Will need to develop the required functionality myself. The tool that I mentioned in the header is obviously no longer available.
0 Comments   [ + ] Show comments


Answer Chosen by the Author

I've not to be honest.  Like VBScab says, it's doable using the API.  It just requires a (fair) bit of legwork.  Alternatively if you just need it 'purely for the visualisation of the relationships between the tables' then InstEd could work?

In this screenshot I have highlighted a row in the Component table and it has told me the relationship at the bottom.

If you wanted some diagrams (although these aren't great) you could try:

Answered 07/19/2016 by: captain_planet
Black Belt

  • Hi Captain,
    thanks for the pointers, was aware of these. If I remember correctly, seeing these relationship diagrams was the initial spark of looking (and eventually) finding something many years ago (must have been around 2002 or so).

All Answers


Sorry, no, I have nothing like that but it's a great idea! It should be too hard to create one, though. As you know, there is an object model and the sample MS scripts could be leveraged to make a start on querying the tables.

You might hit a snag with custom tables but, again, I think one of the sample scripts queries the schema so...

Good luck!

Answered 07/18/2016 by: VBScab
Red Belt

  • I would sit down and try it myself, but as I mentioned, someone has already done it. I did have the application (command line tool) but cannot find it anywhere... Perhaps EdT has it in his bag of tools...
in the past if we have had to do this we have exported the tables from orca, then run a bat file that renames the ibt files to .txt and runs a bulk import to a new access database file named after the package, i will try and dig it out if i can
Answered 07/18/2016 by: sparky86
Fourth Degree Brown Belt

  • Hi Sparky, would be nice if you could share your example as a kick-off point...
Hi Guys,
thanks for the feedback...
I was hoping to avoid having to program it myself (bit lazy at the minute) as it really is only donkey work (Read _Tables, for each entry read the _Columns, assign, check for FK's perhaps read through the _Validation to ensure that the FK's are valid, build the classes and then dynamically build the (access) db... lot's of footwork..
When I have a spare couple of days I'll sit down and have a look.

Answered 07/20/2016 by: Pressanykey
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ