• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1278
  • Last Modified:

How would I import tables from VM$ into Access?

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,
Phil
0
rotnfire
Asked:
rotnfire
  • 3
  • 3
2 Solutions
 
dannywarehamCommented:
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.
0
 
rotnfireAuthor Commented:
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.

Phil
0
 
dannywarehamCommented:
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...
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
rotnfireAuthor Commented:
I do have the original application for the database, but there are no export features in it.  I have looked.
0
 
dannywarehamCommented:
What's the application?
Can you ODBC connect directly to it?
0
 
rotnfireAuthor Commented:
Cannot ODBC directly to it.  It is non ODBC compliant.

The application is called AVImark.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now