I suspect that Oracle is trying to return more characters to at least
one of your MS Query fields than the field can handle. For example, if
Oracle returns 1000 characters and your MS Query field can only handle
256, you would get that error.
Check the field sizes for the Oracle data. If that situations exists,
you might want to try changing your SQL to something like:
SELECT LEFT(oracleField1,256) as MyField . . .
Does that help?
Ron
--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread:
http://www.excelforum.com/showthread...hreadid=378961