OK, well the clue is here: "The value could not be converted because of a potential loss of data." You're trying to push in a value that's not convertible to your SQL table's data-type.

The only thing I can suggest now is that you start with the first worksheet and see if that works, and then move on to the next and so on until it falls over. Then, when you know which worksheet is causing the problem (it might be the first) go through just importing column by column. Sooner or later you'll find the column which is causing the problem, and then take a look at it.

I would think it's likely that your problem is either string -> int, or string -> bool.