?
Solved

How would I import tables from VM$ into Access?

Posted on 2008-10-11
6
Medium Priority
?
1,271 Views
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,
Phil
0
Comment
Question by:rotnfire
  • 3
  • 3
6 Comments
 
LVL 26

Assisted Solution

by:dannywareham
dannywareham earned 400 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.
0
 

Author Comment

by:rotnfire
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.

Phil
0
 
LVL 26

Expert Comment

by:dannywareham
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...
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 

Author Comment

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

Expert Comment

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

Accepted Solution

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

The application is called AVImark.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses

599 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