Adding my 2 coppers here:
MS Access can do a darn good job importing old databases (db), but it's not perfect. It really depends on you, your skills/knowledge, and the amount of time you can devote to it.
If an older database can export to plain or delimited text (foxpro, clarion, etc), that works well. Then you can import through Access's wizard with some fine tuning.
Sometimes, I can get away with importing a large db directly into Access and create some update queries to 'massage' the data, truncating spaces and fixing the formatting. I find this can save time over trying to export from an older db.
There are many options. But for folks to help you they need more information. Like what program created the db (e.g., Foxpro) or what the actual db file name is (e.g., mydata1.dbf). |