Error while importing tables

  • Thread starter Thread starter Lin24
  • Start date Start date
L

Lin24

I am working with a large database that was written in 2000 format. I am
attempting to import tables only (30 tables) but one table refuses to import
i keep getting the following error. I've even reduced the size and tried to
import just that one table. Does anyone know what this error means and how I
can get the table to my new Database in Ver 2007? Would it be better to just
recreate that one table at this point since all the others seem to be fine?

"operation is not supported for this type of object"

Thanks In Advance.
 
A couple of possibilities:

1. Your database is corrupt but you never noticed it. Make a copy first.
Then do a compact and repair on the original.

2. There's some datatype in it that 2007 can't handle. I don't know what
that would be. Possibly you could link the table to 2007 then used an append
query to import the data into another table. Or export the data into
something like Excel or CSV format then import it into 2007.
 
Back
Top