VP-Info database

I have been using a dBase III clone called "VP-Info" since 1986, and I've been running it on a Windows 3.1 computer (that is not Y2K).  I want to transfer the data to Access97 but it does not recognize the format (I tried as dBase III format).  I tried importing into Access ver2 on the same copmuter without success.  I tried calling phone numbers from 1992 for Sub Rosa Publishing  (out of Minneapolis MN) but it's not their phone number any longer.  I search the internet for "sub rosa" and "vp info" without any luck.  This database contains infomation on 50 million negatives of film, so it is important to try and transfer if I can.  
Other question:  If I'm not able to transfer into an Access format, should I be able to transfer the VP-Info programs to the new computer (in DOS) and still run them.  The original VP-Info disks are 5 1/4" floppies and I don't have that type of drive any more--so can I copy the entire VP-Info directory from the old computer and put it on the new?
regiscopeAsked:
Who is Participating?
 
BrianWrenConnect With a Mentor Commented:
Well, if this is a robust dBase III clone then you should be able to write a function which will skip through the records, and print them to a text file.  Put all of the info from each record on a line by itself, then send a carriage return/LineFeed character toi the file, and move to the next row.

Barring that, mabe you could set up a 'printer' which is 'Generic Text on File,' and 'print' the data to a file, then import into Access.

Brian
0
 
regiscopeAuthor Commented:
Edited text of question.
0
 
BrianWrenCommented:
Try using VP-Info to export the information into a text-file, delimited-File, etc., that is a format the Access can then import.

Brian
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.

 
regiscopeAuthor Commented:
I know how to export Access to text file, but I'm not familiar with how to export the dbf in VP-Info.  It does not have the options like Access to pick a format for exporting.  So is there some method to export a DOS-based database file into a text format?
0
 
DedushkaCommented:
Try to open your dbf(?) files with other Xbase products: Fox, Clipper, Dbase, etc. If seccessful - save in other format which can be read from Access.
0
 
tomk120999Commented:
These are some thoughts:
1. 5-1/4 floppies (how many?) can't contain much mB's @ 1.2mb per disk.  What is the database file (.mdb) limit?  1GB total for a .mdb in 97?  Or is it 3?

2. Can you export to .txt or ASCII format from 'VP-Info'?

3. 50 *Million* records won't fit in Access 97 (I don't think).  Maybe I misunderstood, 'cause you say, 'negatives'?

4. If you can export data at all, as .txt or ASCII format, from 'VP-Info', then you should be able to import them to Access, if in no other format.

Maybe this didn't help because the previous suggestions are what I was thinking, but I'm trying to clarify the question.  Thanks for your patience.

HTH.  good luck as usual...
0
 
regiscopeAuthor Commented:
I was able to load a backup copy of my programs in VPI into my new computer, but I had to do it thru Windows "Run" because otherwise it did not recognize the program and allow the printers to print.  I'm still having a little problem getting a couple things to print, but I'm at least able to update the information and have it there until I can get a new program written in Access.  I've created the databases in Access, it is now finding the time to get the programs written.  I appreciate your help, sorry I did not get back to this sooner, but but when you are the sales, service, tech, bookkeeper +, it doesn't leave a lot of time.  Again Thanks.
0
All Courses

From novice to tech pro — start learning today.