Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Nutshell(1984) export issues (yes, i checked the archives:))

Status
Not open for further replies.

tigger36

Technical User
Jun 13, 2005
7
US
Ok this is the problem. My boss created several databases in a DOS program called Nutshell(1984). The contacts database file alone is over 3000 records. I want to export these files into something post-stoneage(i.e.SQLServer). I am a relitivaly accomplished data manipulator, but this thing is killing me.
I know:
1. that it exports into a file format of .db and it is propritary.
2. it is the original version and it is no longer supported by the writters.
3. Windows XP pro does recognize it as a Database file.
I have tried:
1.Importing into every database I can think of small and large.
2.Opening files in word pad and saving various ways.
3.Opening files in MSWORD and converting the files text to eliminate the code from the file.
4. Oh just forget even trying Excel...

???
Short of simply re-entering the data (not a happy thought) has anyone been successful at importing this data into anything else, and how and what? I am even willing to go back to something that was written in that era that might have a chance like dbase or something temporarly. Or, is it possible to write an ODBC driver for it? Keeping in mind, although I have done my fair share of programming I have never written a driver.

Heeeeelllllppppp Please I am so sick of this DB it is not even funny....[sadeyes]
Thanks
Tigger

Tigger,

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~

How many C++ programmers does it take to change a light bulb? ..............
You're still thinking procedurally. A properly designed light bulb object would inherit a change method from a generic light bulb class, so all you'd have to do is send a light bulb change message.
 
I believe Nutshell was based on FileMaker. Don't know if the file formats are the same but an enquiry on a FileMaker forum might bring help.

If you've not cracked it by the end of the day - get a temp in on Monday. The data's DOS-based so some of it must be years old and many of the contacts will be out of data. Call it a "data cleansing process" and hire someone to check and reenter all the data.

Geoff Franklin
 
Have you tried to import the data into Excel? Also have you tried opening the file in dbase or Paradox???? There are a number of databases that use the .db extension. For more info, I did a Google search for .db file format. There is lots of info to help you.
 
You can run Nutshell under Win98, open the file, and export to dBase 2 format which lots of things can read.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top