Import data between tables

[jk]

Hi,

Somehow one of my databases has gotten corrupted.I need to import data from
three tables into a copy of this database....same structure...same design.I
have tried importing the tables but errors continue....i then need some
method in which the data can just be transferred.Is there a way and what
steps do i need to take....thanks

 

[Joe Fallon]

You can link to the other DB and then use a query to extract the data into a
local table.

Or you can export the data from the corrupt file to Excel and then import
that to the new one.