I have a dBase IV file that I need to import into Access, modify, and then export to a dBase file.
I need the record order to be maintained (i.e. the first physical record in the original dbase file must be the first physical record in the new dbase file). There is no field in the original dbase file that can be sorted in order to retain the original physical record order.
How can I use ACCESS 2007 to write a new dBase file that retains the origina dbase file record order? I am finding that Access is reordering the records during export.
I need an answer to that specific question