Import Problem

S

Samuel

When I try to import a specific table I get the following error:
You tried to assign a value to a variant that is not a variant type

What can be the cause of this problem?

Thank you,
Samuel
 
K

Ken Snell \(MVP\)

Could you tell us how you're doing the import? manually? which steps? macro?
VBA code? etc.
 
K

Ken Snell \(MVP\)

Sounds like the table that you're trying to import is corrupted....

Can you import a different table from that file? Does that work ok?

Try creating a brand-new .mdb file, and try to import the table. Does that
work ok?
 
S

Samuel

All tables work except that

Thank you,
Samuel

Ken Snell (MVP) said:
Sounds like the table that you're trying to import is corrupted....

Can you import a different table from that file? Does that work ok?

Try creating a brand-new .mdb file, and try to import the table. Does that
work ok?
Click to expand...
 
Top