Import Problem

  • Thread starter Thread starter Samuel
  • Start date Start date
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
 
Could you tell us how you're doing the import? manually? which steps? macro?
VBA code? etc.
 
File>Get External Data>Import


Ken Snell (MVP) said:
Could you tell us how you're doing the import? manually? which steps?
macro? VBA code? etc.
Click to expand...
 
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?
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Error 3162 - Null Value To A Variable 1
Error 3162 - "You tried to assign the Null value" 0
Trying to run excel vba code when cell value changes from empty to entered value. 1
Using recordset to copy decimal type from one table to another 4
Table corruption 3
how to create new record automatically 2
Import Of data to table 3
Excel. VBA match doesnt work while WS does 0

Back
Top