By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,196 Members | 1,784 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,196 IT Pros & Developers. It's quick & easy.

access97 & .copyFromRecordset different when using sql server 2005

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.