471,872 Members | 1,031 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,872 software developers and data experts.

access97 & .copyFromRecordset different when using sql server 2005

can anyone explain this ?
originally using access97 with a linked table to an mdb backend, to
create a worksheet using
SELECT * FROM qryIPS WHERE location = 999
and it works fine with either excel97 or excel2003

moved backend mdb tables to sql server2005 and relinked
location field in both cases is a long integer

but the above statement no longer works with either version of excel
when doing
.range("A2").CopyFromRecordset rst

but SELECT * FROM qryIPS WHERE location like 999, works fine

I don't under why '=' doesn't work ? and 'like' does ?
note, changing the query qryIPS to include the where clause "location
= 999" and just using
select * from qryIPS, doesn't work either, yet the query gives me
that information I need

Feb 4 '08 #1
0 1181

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.