link table question

[Guest]

I have a database that is linked to a *.dbf file. I would like to unlink
this and somehow have the data in a mdb file. Can I do this?
Thanks!

 

[Joseph Meehan]

That would involve importing the data from the .dbf file to the .mdb
file. Since you already have the file linked, why not just run
make-table queries to extract from each linked table and put the data
into a local table?

Then delete the original table in Access (it will only delete the link.

 

[Dirk Goldgar]

I have a database that is linked to a *.dbf file. I would like to
unlink this and somehow have the data in a mdb file. Can I do this?
Thanks!

That would involve importing the data from the .dbf file to the .mdb
file. Since you already have the file linked, why not just run
make-table queries to extract from each linked table and put the data
into a local table?