I'm in the process of redesigning a database. The database was designed by someone who had a fair amount of knowledge of Access but zero knowledge of "correct" database design. There are very few primary keys, tons of redundant data, and 24 tables with about 3 actual relationships.
Here is my problem, the only thing I would like to keep from the old database is portions of the data. The rest needs to go straight into the garbage. How can I gleen just certain rows and columns of data without maintaining any of the structure of the old database (names and all)?