Passing excel cell values as sql variables
 

Hi,
Is there anyway I can pass excel cell values as sql variables???

Regards

Jaideep

Passing excel cell values as sql variables
 

sSQL = "SELECT * FROM myTable WHERE id='" & Range("A1").Value & "'"

as I have assumed the id is a string, I have enclosed it in single quotes.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"jai" wrote in message
ps.com...
Hi,
Is there anyway I can pass excel cell values as sql variables???

Regards

Jaideep

Passing excel cell values as sql variables
 

Hi

I this is for use in MSQuery, then Nick Hodge has a great article he

http://www.dailydoseofexcel.com/arch...-data-queries/

Best regards

Richard


jai wrote:
Hi,
Is there anyway I can pass excel cell values as sql variables???

Regards

Jaideep

Passing excel cell values as sql variables
 

.... I this is for use in MSQuery ...

odd, I thought you were English <vbg

"RichardSchollar" wrote in message
oups.com...
Hi

I this is for use in MSQuery, then Nick Hodge has a great article he

http://www.dailydoseofexcel.com/arch...-data-queries/

Best regards

Richard

Passing excel cell values as sql variables
 

It would seem that the copious quantities of mulled wine consumed this
Christmas have addled my brain ;-)

Richard hic...


Bob Phillips wrote:

... I this is for use in MSQuery ...

odd, I thought you were English <vbg

"RichardSchollar" wrote in message
oups.com...
Hi

I this is for use in MSQuery, then Nick Hodge has a great article he

http://www.dailydoseofexcel.com/arch...-data-queries/

Best regards

Richard