I don't use MSQuery so I can't answer your first question, but the
incorrect syntax is probably due to the concatenation "FROM tbl1" &
"WHERE ApplicationName Like 'java'" - this results in "FROM tbl1WHERE
ApplicationName Like 'java'". You could replace this:
cmd.CommandText = "SELECT ApplicationName " & "FROM tbl1" & "WHERE
ApplicationName Like 'java'"
with this:
cmd.CommandText = "SELECT ApplicationName FROM tbl1 WHERE
ApplicationName Like '*java*'
For more info on SQL check out
www.sql.org
Col
--
colofnature
------------------------------------------------------------------------
colofnature's Profile:
http://www.excelforum.com/member.php...o&userid=34356
View this thread:
http://www.excelforum.com/showthread...hreadid=548912