?
Solved

Importing and converstion of a Cardbox database

Posted on 1998-05-07
2
Medium Priority
?
431 Views
Last Modified: 2012-08-14
I have some Card box databases, which a friend gave me, thinking that I would be able just to import them into MSaccess. I find that I cannot.  Is there a way?  These files are important to me.  HELP please.
0
Comment
Question by:manner
2 Comments
 
LVL 7

Expert Comment

by:Victor Spiridonov
ID: 1964147
What is the format of those files? What extension do they have?
0
 
LVL 9

Accepted Solution

by:
cymbolic earned 200 total points
ID: 1964148
Access has excellent text import capability, and most proprietary database formats will yield to a custom extraction program that results from examining the format with a hex viewer, such as Verne Buerg's List program in Hex mode.  You don't have to know the format in detail, you only have to see enough regularity in the data structure for you to build and run a simple binary extract program.  I have built many of these in basic, using binary file I/O, and programmed offsets and/or byte/bit examination of input stream for token markers.  If you can find no ready translator, I'd be happy to take a look at converting your data to a flat text file, for import into Access (cymbolic@aol.com).

However, your best bet is to activate the exisiting system that created the files, and see if it has either an export function, or, just run reports to a file, then process/import from the report files into Access.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Implementing simple internal controls in the Microsoft Access application.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

609 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