I need to add a field to a dBase IV table that is already loaded with data. I know the table structure can not be changed once the data is loaded, so I need a way to quickly transfer the data to a new table definition. I have tried doing this the hard, ugly way - creating a new dBase file and copying over the data field by field and record by record. It worked, but it is way too slow. There must be a better way.
Is it possible to convert the .dbf file to another format (such as .mdb), then add and populate a new field, and finally convert the table back to a .dbf file? Is there a better/faster way?