How would I import tables from VM$ into Access?

Posted on 2008-10-11
Last Modified: 2013-11-15
I am trying to import the tables from a piece of software into Access for conversion purposes.  The database shows the extensions "vm$", "da$", "di$", and "ix$".  It seems the most important file extension is vm$.  Does anyone have experience in this area?  Any help would be most appreciated.

Best Regards,
Question by:rotnfire
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 26

Assisted Solution

dannywareham earned 100 total points
ID: 22694681
I've never heard of the vm$ as an extension to a programe file.

Having said that, Access can import from any datasource that is compatible with ODBC

Go into Access and click import (right cick on tables screenand select from list).
In the drop down at the bottom, change yoru source typefrom Access to ODBC databases.
You should be able to select your other database and the wizard will walk you through the connection.

Author Comment

ID: 22696014
It seems this is not an ODBC database.  The individual tables are in separate files.  Each is listed on its own.  I show a total of 172 files in the folder.  This is not a database maintained in it's own file, but rather, each table is it's own file, and possibly each table is comprised of 3 separate extension files, namely vm$, da$, and ix$.  I think I'm out of luck on this, and must look at some other method of mining this data, not using access.  I could compress some files, and email to individuals to look at.  But I cannot post on Expert Exchange because the files to fit the limitation of the extensions allowed for posting.

LVL 26

Expert Comment

ID: 22696693
That's a bit pants.
The extensions are odd. I've not seen one with a special ($) character in them before.
Do you have the original database application?
We could search for a way to import from there...
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 22708791
I do have the original application for the database, but there are no export features in it.  I have looked.
LVL 26

Expert Comment

ID: 22709713
What's the application?
Can you ODBC connect directly to it?

Accepted Solution

rotnfire earned 0 total points
ID: 22879918
Cannot ODBC directly to it.  It is non ODBC compliant.

The application is called AVImark.

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question