S
Stopher
Hi All first post.
I am currently having a problem returning a value into a cell in excel
2000
I understand the ADO connection, and have checked my sqlSTR in query
analyser.
I use the following to dump to a cell.
Set rcset = New ADODB.Recordset
rcset.Open sqlstr, dbmain, adOpenKeyset, adLockOptimistic
Sheets("Sizing").Range("b19").CopyFromRecordset rcset
What I have used this to dump the whole record set out, but the sqlstr
I am using only has a specific value in it. I am currently getting
#value in my cell, and am wondering if the value coming out of the ADO
dump is actually text.
Is there anyway to specify the value coming out of the rcset is a value
and not text?
I am currently having a problem returning a value into a cell in excel
2000
I understand the ADO connection, and have checked my sqlSTR in query
analyser.
I use the following to dump to a cell.
Set rcset = New ADODB.Recordset
rcset.Open sqlstr, dbmain, adOpenKeyset, adLockOptimistic
Sheets("Sizing").Range("b19").CopyFromRecordset rcset
What I have used this to dump the whole record set out, but the sqlstr
I am using only has a specific value in it. I am currently getting
#value in my cell, and am wondering if the value coming out of the ADO
dump is actually text.
Is there anyway to specify the value coming out of the rcset is a value
and not text?