In Ms Access
File>get external data>Import
Yes you will loose the indexes you will need to create new indexes in Access.
If you use File>get external data>Link tables
The data will stay in the DBF but be accessible from Access as if it where an Access table. The Indexes will be maintained.
Dave M.
|