Import type mismatch (1 Viewer)

jsic1210

Registered User.
Local time
Yesterday, 22:29
Joined
Feb 29, 2012
Messages
188
Hello,

I created some VBA imports from a saved Excel file. When I run it on my computer, it works fine. When my coworkers run it, they get an error "Type mismatch." Some files seem to upload despite the error, but I'd like to figure out why it's happening, especially for cases where the data doesn't import. As a band-aid, I added a line in my error handler that says if the error = "Type mismatch." then just resume.
 

jdraw

Super Moderator
Staff member
Local time
Yesterday, 22:29
Joined
Jan 23, 2006
Messages
15,379
So you are importing an Excel file directly into an Access table, correct?
What field is giving the mismatch? What is the data type of that field in the Access table?
 

jsic1210

Registered User.
Local time
Yesterday, 22:29
Joined
Feb 29, 2012
Messages
188
The thing is, it's no field specifically. There are no error tables that produce from it. And it works just fine for me.
 

Users who are viewing this thread

Top Bottom