i know that this problem occurs to many of us....(base on the forums i seen)...but i still cant figure out why ...i got this error...due to the sql statement...
....basically i was trying to link up with the excel db....from vb6.....which did successfully..and when i use select * [xxx$]....it works too..but when i add addition condition ( ie.select....WHERE [xx... ] i got an error saying data type mismatch for criteria expression...
Reply With Quote