Transferring data from old data base to Access

AI Thread Summary
DBase is an older database management system that was widely used in the past, particularly for its simplicity in handling data. Transferring over 20,000 entries from DBase to a modern database like Access is feasible without manual entry. Various conversion programs are available, typically costing under $500, that can facilitate this process. If the data structure is relatively simple, exporting the DBase entries to a CSV format and then importing them into Access is a straightforward solution. Additionally, Excel can directly read DBase III files, providing another potential method for data transfer. Historical context highlights that dBase and its derivatives, like FoxBase, were more user-friendly for certain applications compared to Access, which has faced criticism for its complexity in comparison.
John O' Meara
Messages
325
Reaction score
0
Hi,
I have a friend who has a friend who has a data base of 20000+ enteries. This data base was constructed using something called D base nearly twenty years ago. Now, they want to know is it possible to transfer the 20000 odd enteries to a modern data base without having to type in the enteries individually to the new database like Access.
(1) What is D base, does anyone in this forum know?
(2) Is it possible software wise to copy the D base enteries to Access or other new data base and if so how?
Thanks for helping.
 
Technology news on Phys.org
Google is your friend. There are lots of conversion programs out there. The cost should be under $500.
 
If the data is reasonably flat (ie not a complex set of linked tables) then just dumping the dbase format to comma separated fields (CSV) then importing it into access would be easy.

IIRC Excel will read DbaseIII files into a spreadsheet directly.
 
Ashton Tate dBase was a wonderful program, and it was pretty much reverse-engineered as FoxBase, which also included a nice compiler. MS bought FoxBase before releasing the perversion that is Access, and they should have provided free conversion tools. Having written application programs for dBase and FoxBase for years, I was quite disappointed with Access when I ended up having to build some very simple applications (it would have been far simpler in dBase or FoxBase) for a customer.
 
Dear Peeps I have posted a few questions about programing on this sectio of the PF forum. I want to ask you veterans how you folks learn program in assembly and about computer architecture for the x86 family. In addition to finish learning C, I am also reading the book From bits to Gates to C and Beyond. In the book, it uses the mini LC3 assembly language. I also have books on assembly programming and computer architecture. The few famous ones i have are Computer Organization and...
I have a quick questions. I am going through a book on C programming on my own. Afterwards, I plan to go through something call data structures and algorithms on my own also in C. I also need to learn C++, Matlab and for personal interest Haskell. For the two topic of data structures and algorithms, I understand there are standard ones across all programming languages. After learning it through C, what would be the biggest issue when trying to implement the same data...
Back
Top